Create field that lists which other records are duplicates 1

[CTOROCK]

Hello,

I am trying to create a field that displays all the different stores that an item ships to in a sting. I can find duplicates which indicates that they ship to more than one store, but I would like to create a string and add it to a new field of "Other Stores Shipped to".

i.e. If Item 214 shipped to C, D and F I would like a singe record of item 214 with a field that indiates "C,D,F" etc. Any ideas or information is greatly appreciated. Thanks in advance for any help.


"The greatest risk, is not taking one."

 

[dhookom]

Check out the generic concatenate function at faq701-4233

Duane
Hook'D on Access
MS Access MVP

 

[CTOROCK]

Great reference, Thanks! Here's a star!

The greatest risk, is not taking one.