[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 59
  • Last Modified:

Concatenating data within ACCESS table

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
kerikeri
Asked:
kerikeri
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
here is a sample db,
look at query1 and the codes in the module modconcat
concat.mdb
0
 
Rey Obrero (Capricorn1)Commented:
here is the correct sample db
see query1, codes in modConcat
concat.mdb
0
 
kerikeriAuthor Commented:
Wow, your module is perfect.  Thanks so much Rey!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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