Prev: Date expression in Query
Next: How do I bring a filed from multiple records and join them togethe
From: Jennifer on 14 Apr 2010 11:56
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
From: John Spencer on 14 Apr 2010 20:34
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

Jennifer wrote:
> 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
 | 
Pages: 1
Prev: Date expression in Query
Next: How do I bring a filed from multiple records and join them togethe