Combining Dup Info

[Jennifer]

I have a table (tbl1) that has Invoice # and Item Desc as Fields (the info i
used is fictitious) :

Inv # Item Desc
50014 Cheetos
50014 Gum
50014 Cigarettes
61032 Candy
49544 Soda

I have another table (tbl2) that has the same Inv # and a "Comments" field.
I want to link by Invoice # and update the comments field to show all item
desc for that given invoice #. Is there a way I can combine each Item desc
into one text string and populate the comments field on tbl2?

Thanks,
Jennifer

 

[John Spencer]

One way is to use VBA function to concatenate the values.

Here are links (url) to three examples.

Duane Hookom
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16

Allen Browne
http://allenbrowne.com/func-concat.html

The Access Web
http://www.mvps.org/access/modules/mdl0004.htm


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County