Avatar of Pete Grieves
Pete Grieves
 asked on

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!
Printers and ScannersMicrosoft Access

Avatar of undefined
Last Comment
Pete Grieves

8/22/2022 - Mon
Pawan Kumar

can you please provide few rows from all the input tables and the expected output.
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Pete Grieves

ASKER
I was able to create a module that concatenated the results. Thank you!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy