Separating Field Info with commas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dmich - 23 Apr 2008 07:46 GMT

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

Reply to this Message

Marshall Barton - 23 Apr 2008 16:08 GMT

>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
[quoted text clipped - 4 lines]
>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/Otherdownload.asp?SampleName='Generic%20Funct
ion%20To%20Concatenate%20Child%20Records'

Signature

Marsh
MVP [MS Access]

Reply to this Message

KARL DEWEY - 23 Apr 2008 16:10 GMT

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?

Signature

KARL DEWEY
Build a little - Test a little

> 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
[quoted text clipped - 6 lines]
> Thanks
> dmich

Reply to this Message

dmich - 23 Apr 2008 23:11 GMT

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

> You need to post more information. How about some sample data and display
> of what that would look like in your report.
[quoted text clipped - 10 lines]
> > Thanks
> > dmich

Reply to this Message