Denormalize for export

[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

 

[Tom van Stiphout]

On Sat, 19 Jul 2008 13:47:48 +0200, "Lars Brownie" <[email protected]>
wrote:

Check this out:
http://www.mvps.org/access/modules/mdl0004.htm

-Tom.
Microsoft Access MVP

 

[Lars Brownie]

Great! Exactly what I need.
Thanks

Check this out:
http://www.mvps.org/access/modules/mdl0004.htm

-Tom.
Microsoft Access MVP