Solved

Crete unique table with concatenation of second field

Posted on 2014-03-04
4
262 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
ID: 39905232
0
 
LVL 3

Author Comment

by:fordraiders
ID: 39905569
coachman99, no thanks, but using methods not in vba
0
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 39905636
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
ID: 39905744
That worked perfect...
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

809 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