building strings based on common ID

[Guest]

Hi, I have the following result from a query that calls for all records of
"38E":

musym UserSite component_id2
38E 052032 None assigned
38E 052033 a
38E 061023 b
38E 061040 a
38E 061042 a
38E 061043 a
38E 061048 a
38E 061050 b
38E 061051 a

What I would like to do is group all UserSite values together based on
component_id2 values in a datasheet, so result would look something like this:

musym component_id2 UserSite
38E None assigned 052032
38E a 052033, 061040, 061042, 061043, 061048, 61051
38E b 061023, 061050

The reason for this is so I can then post the UserSite values in a report,
and the UserSite values will list from left to right, and not top down, and
save much paper space. Any help appreciated.

 

[Douglas J. Steele]

You can't do it without using a function.

Take a look at http://www.mvps.org/access/modules/mdl0004.htm or
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web" for
ideas.