How to make a query that looks like a report with different groupings

[allj]

Hope you had a good Thanksgiving!! I am stumped. I am trying to make a query that looks like the report with different groupings but one that is exportable to a delimited txt file. In my case a header of several fields a body of continuous records and a trailer of footer. I then need to export it to delimted txt with the separator being *. A simplified version would be like this:
The header is Mdb*x432*date*>*
The detail is a loop with rcds like:
rcd1*date*id*srv*address**rcd2*date*id*srv**rcd3*d ate*id*srv*
and a trailer like tr*date

Everything is exported to delimted txt and should look like the following.
Mdb*x432*date*>*rcd1*date*id*srv*address**rcd2*dat e*id*srv**rcd3*date*id*srv*tr*date

I have made union queries trying to compensate for different # of fields by concatenating them but when exporting they maintain the same number of columns in the delimited file as the query even without wordwrap on in wordpad. I hope this is clear. I am getting desparate- any suggestions are greatly appreciated. Alan

[allj]

I think I can do this with a crosstabqry. If not I will get back to you. Thanks anyway. Alan