Separating Field Info with commas

[dmich]

I have an inventory db, right now when I run a report for the unit id's, the
report will create a text box for every unit id entry, I have look
throughtout the disscussions and haven't had any luck, I may be searching
wrong, but here is what I would like for my reports to look like;
(ABC-100,ABC-101,ABC102), an so on but instead each inventory item is listed
in its own text box.
any help would be much appreciated
I am running access 2003
Thanks
dmich

 

[Marshall Barton]

I have an inventory db, right now when I run a report for the unit id's, the
report will create a text box for every unit id entry, I have look
throughtout the disscussions and haven't had any luck, I may be searching
wrong, but here is what I would like for my reports to look like;
(ABC-100,ABC-101,ABC102), an so on but instead each inventory item is listed
in its own text box.
any help would be much appreciated
I am running access 2003

If you want to combine a field's values from multiple,
related records, then use a function such as:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

 

[KARL DEWEY]

You need to post more information. How about some sample data and display
of what that would look like in your report.
Are you totaling all units that begin with ABC-1 into a single count?

 

[dmich]

Ok, here is what I would like to accomplish,
here is how it is doing now,
8 x 10 baskets (type of unit)
abc-1 (unit serial numbers)
abc-2
def-309
23-8x10

8 x 12 baskets
102-8-12
432-8-12

and here is what I would like to do

8 x 10 baskets
abc-1,abc-2,def-309,23-8x10
(separated by commas all in one text box rather than having the serial
number in its own text box, I have around 1,800 containers in various sizes)

I can sort and group them into their unit sizes ( 4 x 8 container, 8x10
containers, and so on) but can't get them to go into a single text box
separated by commas,
I don't need to total them

Hopefully I made so sense in what I am trying to accomplish,
again thanks for all the help.
dmich