Solved

Concatenating data within ACCESS table

Posted on 2016-11-21
3
19 Views
Last Modified: 2016-11-21
I need to have one record per crash.  Each crash can have many reasons.  The reasons need to be concatenated together.  Please see attached file for explanation.
DuplicateFields.docx
0
Comment
Question by:kerikeri
  • 2
3 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
here is a sample db,
look at query1 and the codes in the module modconcat
concat.mdb
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
here is the correct sample db
see query1, codes in modConcat
concat.mdb
0
 

Author Closing Comment

by:kerikeri
Comment Utility
Wow, your module is perfect.  Thanks so much Rey!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
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, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

743 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

14 Experts available now in Live!

Get 1:1 Help Now