Link to home
Start Free TrialLog in
Avatar of kerikeri
kerikeriFlag for New Zealand

asked on

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
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

here is a sample db,
look at query1 and the codes in the module modconcat
concat.mdb
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kerikeri

ASKER

Wow, your module is perfect.  Thanks so much Rey!