Solved

Crete unique table with concatenation of second field

Posted on 2014-03-04
4
253 Views
Last Modified: 2014-03-05
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
Comment
Question by:fordraiders
  • 2
4 Comments
 
LVL 7

Expert Comment

by:COACHMAN99
Comment Utility
0
 
LVL 3

Author Comment

by:fordraiders
Comment Utility
coachman99, no thanks, but using methods not in vba
0
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
Comment Utility
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
 
LVL 3

Author Closing Comment

by:fordraiders
Comment Utility
That worked perfect...
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now