A
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: in Ms access
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
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: in Ms access
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