Desperate

[Alan]

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*date*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*date*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

 

[Mike Glen]

Hi Alan,

Are you using Microsoft Project? If so, try posting on the developer
newsgroup as this one is closing down. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP