Report to text

[LennyNero]

Hi,

I'm developing a small access db to comply with some specs that were asked.
Its a small hospital we need to send to one of the ensurance company's a report of the things we billed.
Ill be attaching the table of our billing software to make a query for those records.
Now comes the problem, i need to report it as text, each file sent has all the invoices in one month, normaly the previous.
The text file must have:
A header with a unique number and some other fields easy to add
The details must have all the lines in the previous month plus a calculated field for quantity*mediccare
The footer contains the total number of details and the sum of all values.

I created 2 tables, 1 for header and footer and one for the details. then a temp table that imports the values and appends to the details. (here i cant figure out how to link the details i imported to a header number)
I tested the export to text with just the values of the header and it went fine. (i have the code made, although i cant name the file with values from database dont know how).

I know my questions are a little vague but i can specify, im just looking for ideas how to make this , im really stuck, appreciate all help i can get.

Thanks
Luis

Now i cant figure out how to join all data and put it all in the same file

 

[GaryPanic]

why do it this way

can you get the report done in access (using access reports ) if so file save as txt should do it (I could be way out of line on this, but just tried this on one of my reports and it look reasonable ok)