Reciept log

[xmrchndize]

Here it goes....

I have some receipt logs that are written by my POS software. At the same time the log is written there is an entry made in my database (Access) with the path and receipt ID for the entry. The entry in the database for example looks like this; each item is a column in the database.

Trans Number: D2073
Log File: Logs\DRLog032005I.log
Receipt: D38592207362963

The receipt log file that corresponds to this is located in the Logs directory and is file name DRLog032005I.log

Ok now the fun stuff

Here is a clipping from one of my receipt logs this is actually two receipts one of them corresponds to the above mentioned receipt the other is the sequential log entry. As you can see there is a lead in and lead out for each receipt.

What I am trying to do is display a single receipt from the log on a page for the purpose of printing. I already have the database connection established and I know how to get the information from the database to the fields that I need to. What I do not know is how to call in the information from the log files. Any help will be greatly appreciated

Ex. lead in    "<RECEIPT>D38592207362963" 
Ex. lead out  "D38592207362963</RECEIPT>"


<++++++++++++++++++++++++++++++++++++++>
<RECEIPT>D38592207362963

  RETURNS, EXCHANGES, AND CREDITS
 WARRANTED WITHIN 10 DAYS OF SALE,
 AND ONLY IF RECEIPT IS PRESENTED!
            THANK YOU!


Transaction#: D2073
CLERK: CORY
Date: 08/28/2005     Time: 08:18:45 AM

Due Date: 09/10/2005

            *** SALE ***

Bill To:
Customer # ****
CORY *****
P O BOX ***
GRAY, LA *****
***-***-****

 ____________________________________

5109WB 6V UTILITY LANTERN
6373518
   2.00 EA @   $5.99 T          $11.98
   074196003077
11863 6 GAL WATER CAN
6559165
   2.00 EA @  $10.15 T          $20.30

                      Subtotal: $32.28
         4&#37; Louisiana State Tax: $1.29
     4.5% Terrebonne Parish Tax: $1.45
                         TOTAL: $35.02

                       INVOICE: $35.02
                         CHANGE: $0.00


 (X)__________________________________
        Authorized Signature

A Finance Charge of 1.5% per month
  applies to all past due invoices


 .-----------------------------------.
  HOURS = 7-6 M-F,  8-5 SAT,  8-3 SUN
             ***-***-****
  ***************  HOUMA, LA *****
D38592207362963</RECEIPT>
<++++++++++++++++++++++++++++++++++++++>
<RECEIPT>D38592208775926

  RETURNS, EXCHANGES, AND CREDITS
 WARRANTED WITHIN 10 DAYS OF SALE,
 AND ONLY IF RECEIPT IS PRESENTED!
            THANK YOU!


Transaction#: D2087
CLERK: CODY
Date: 08/28/2005     Time: 10:55:58 AM

Due Date: 09/10/2005

            *** SALE ***

Bill To:
Customer # ****
AMERICAN MACHINE & MFG., LLC
P O BOX ****
HOUMA, LA *****
***-***-****
 ____________________________________

5109WB 6V UTILITY LANTERN
6373518
   3.00 EA @   $5.99 T          $17.97
   074196003077
ONE  PRO CELL C BATTERY
PCCB
  24.00 EA @  $1.014 T          $24.34

                      Subtotal: $42.31
         4% Louisiana State Tax: $1.69
     4.5% Terrebonne Parish Tax: $1.90
                         TOTAL: $45.90

                       INVOICE: $45.90
                         CHANGE: $0.00


 (X)__________________________________
        Authorized Signature

A Finance Charge of 1.5% per month
  applies to all past due invoices


 .-----------------------------------.
  HOURS = 7-6 M-F,  8-5 SAT,  8-3 SUN
             ***-***-****
*****************  HOUMA, LA *****
D38592208775926</RECEIPT>