categorize same type in report

[msasan1367]

see my program:
test.mdb

how to categorize same type in report?
I mean I have two "prt1" in form, now in report show it like this:

type	weight	meter
prt1	4 | 2	2 | 1
prt2	3	3
prt3	5	10

[offie]

I didn't look at the file but I'm assuming you have something like this to start
prt1 4 2
prt1 2 1

And you just want to get all the info into 1 field?
Try: http://allenbrowne.com/func-concat.html
You can change the "," and anything you want between the values