Query from datasheet

[sharpnote]

I need your help. How do you group or summarized result of Query1 to appear like in Query 2. The source of data of field3 is from a datasheet form where multiple data is stored. I tried using assignedto and value but apparently it is only for combo/list box source data.

Query 1

Field1 . . . . . . Field2. . . . . . . Field3
1a. . . . . . . . . red . . . . . . . . . . ball
1a . . . . . . . . .red . . . . . . . . . . shoes
1a . . . . . . . . .red . . . . . . . . . . car
1b . . . . . . . . .blue . . . . . . . . . .water
1b . . . . . . . . blue . . . . . . . . . . sun
1b . . . . . . . . .blue . . . . . . . . . . air

into this

Field1 . . . . . . Field2 . . . . . . . .Field3
1a . . . . . . . . . red . . . . . . . . . .ball, shoes, car
1b . . . . . . . . . blue . . . . . . . . . water, sun, air

 

[Galaxiom]

The source of data of field3 is from a datasheet form where multiple data is stored.

Data is not stored in forms. I would expect the data will ultimately be from a table that is part of a query used as the RecordSource of that form.

Your goal could be done with a crosstab subquery and the fields concatenated with commas in between.

The crosstab section would be similar to one shown in this post.

 

[sharpnote]

Thanks Galaxiom, my bad. It is not in the form, I should write, "it is encoded in a datasheet form". Ok, I'll try your suggestion and check out the link. Thanks again. Cheers!