Combining Multiple Like Values in a Query

[WildlyHarry]

I have an Access table that contains accounts and part numbers. It is
possible for there to be mutliple part numbers assigned to one account. The
way the table is designed, there is a seperated record for each part number.
So it is possible for there to be 10 plus records for the same account number
but with different part numbers. Is there a way to write a query so that I
have one record per account number, with all of the part numbers in one field
seperated by comma's? I need to do this to have an excel sheet with one
record per customer for quick reference. I have tried a cross tab query and
then a query based on that to concatenate those values. That will not work
as it is possible for there to be 100's of part numbers per account. Does
anyone have any ideas on how to solve this issue? Thanks in advance for you
help.

 

[Arvin Meyer [MVP]]

This should work:

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

I've never tried it on particularly long concatenations like hundreds of
values.