Exporting Multiple rows to csv as one record

[amanda_jb]

Trying to upload our Access Data information into accounting software, we
need to export the order info to a csv file as one row.
We have the header record (one record), which contains the customer/shipping
info and then we can have multiple records (related by the order id) for all
the parts associated (which varies so I don't think a crosstab could apply,
but not to good at those).
I have written the query which will export all, which leads to all the main
record data being duplicated per each part. Is there a way to eliminate this
and export into one record? Please help!!!!

 

[Clifford Bass]

Hi Amanda,

You may want to check out Allen Browne's ConcatRelated() function at
<http://allenbrowne.com/func-concat.html>.

Clifford Bass