I am attempting to create a flat file that I need to send to a service
processor.
Problem
The file I am creating comes from a query with a one to many join. This
results in several records being reproduced for each entry in the many
table.
I need to append the unique information from the duplicate rows onto the end
of the initial record. In effect creating a record that can be exported in a
flat file as a single row.
I have scoured the access help and online resources and cannot find a
solution.
If someone can point me to a resource or example I can take it from there.
Thanks much for your help. First time poster.