Denormalize for export

L

Lars Brownie

Table A is linked 1 x M to table B. For exporting purposes I need to make
one output table/query that combines the data from both tables, but every
record from Table A should only have one record in the resulting
table/query. Something like:
Fld1 Fld2(of table B)
a Value1, Value2, Value3

in stead of
Fld1 Fld2(of table B)
a Value1
a Value2
a Value3

Any suggestions on how to accomplish this?
Thanks,
Lars
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Help 4
Combine multiple rows into one row with multiple columns 1
Check List in VBA 7
Query based upon another query not returning decimal data 2
Force a value into an empty query 2
Merging three tables 5
Parsing a text field to retrieve numeric values 7
Setting textbox in a form equal to data in a query 1

Top