Combining Dup Info

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

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
 
Back
Top