If I group is there a way to show Field with all The different grops

[evr72]

Hello,

I am not exactly how to explain. I know I can Group a query.

I have a groupped query with two fields Machine and ItemNum.

An item might appear in multiply machines, so I could do a first(Machine) and then a count on the machine field and that would give me the first amchine it finds and how many others the item can run on.
My question is is there a way that I can build a field that shows all the machines the item runs in
for examle
From tnis:
machine Item
500 123
600 123
700 123

to this

Machine Item NewField
500 123 500, 600, 700


Not sure if this can be done

thanks for any help or pointing me in the right direcction

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BigRed1212]

This sounds more like a presentation issue than a data issue.

Given data like:

recordid	machine	item
9	200	234
8	200	789
5	200	345
10	400	123
4	400	234
6	500	567
1	500	123
7	600	678
2	600	123
3	700	123

sorted on machine, your desired result is a report with machine and item grouped on machine. You don't really want the link for creating a comma separated concatenated list of child records....