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

Wrong group, Alan.

"Alan" <(E-Mail Removed)> wrote in message
news:7F62C046-32F7-46B6-ADB8-(E-Mail Removed)...
> 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