Can a Query do this?

[Ellen]

I need to combine sets of records into one record for
export. The number of records is variable (up to 100).
This is for a Bill of Material table. The record needs to
look like... AssemNumber PartNumber1 Qty1 PartNumber2
Qty2.... ect.

Thanks!!!

 

[Van T. Dinh]

Not AFAIK but try VBA according to The Access Web article:

http://www.mvps.org/access/modules/mdl0004.htm