Trying to make fields from multiple records in one table, into a single field in a query

I have one table that shows individual printing jobs and another table that shows the ink for each job. There can be as many as 10 different inks for a single job. The field that connects them is ITEM_CODE, which is in itself a unique number. My output needs to have a single row for each job number, which works fine with the format from the JOB table, but the REQ table has a record for each ink. I'm trying to figure out how to get each ink name into a field in one row of my output. Any help would be greatly appreciated!
Pete GrievesAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
You can "flatten" the records into a single row using the code in this article:

https://www.experts-exchange.com/articles/2380/Domain-Aggregate-for-Concatenating-Values-by-Group-in-Microsoft-Access.html

Jim.
0
 
Pawan KumarDatabase ExpertCommented:
can you please provide few rows from all the input tables and the expected output.
0
 
Pete GrievesAuthor Commented:
I was able to create a module that concatenated the results. Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.