troubleshooting Question

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

Avatar of Pete Grieves
Pete Grieves asked on
Printers and ScannersMicrosoft Access
3 Comments1 Solution91 ViewsLast Modified:
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!
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros