Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Concatenating data within ACCESS table

Posted on 2016-11-21
3
Medium Priority
?
54 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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 41896769
here is a sample db,
look at query1 and the codes in the module modconcat
concat.mdb
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 41896776
here is the correct sample db
see query1, codes in modConcat
concat.mdb
0
 

Author Closing Comment

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

824 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