• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

Crete unique table with concatenation of second field

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
0
Fordraiders
Asked:
Fordraiders
  • 2
1 Solution
 
FordraidersAuthor Commented:
coachman99, no thanks, but using methods not in vba
0
 
als315Commented:
You can take sample from recent question:
Q_28377250
Sample is based on  function DConcat from Patrick G. Mattews article:
Domain Aggregate for Concatenating
0
 
FordraidersAuthor Commented:
That worked perfect...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now