Crete unique table with concatenation of second field

Fordraiders
Fordraiders used Ask the Experts™
on
access 2010

What I have :
1 table  =MyTable
2 fields
MySku-text-dups
MyDesc-text-dups


I have data in the table like this

MySku            MyDesc
1234A            Apples
3EER4             Oranges
1234A            Peaches
232AW           PIE
3EER4             PINEAPPLE


What I need:

I need to create a new query like this:
Concatenate the MyDesc into one line
1234A              APPLES:PEACHES
3EER4               ORANGES:PINEAPPPLE
232AW             PIE


etc....



Thanks
fordraiders
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
coachman99, no thanks, but using methods not in vba
You can take sample from recent question:
Q_28377250
Sample is based on  function DConcat from Patrick G. Mattews article:
Domain Aggregate for Concatenating

Author

Commented:
That worked perfect...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial