<div>
can you please provide few rows from all the input tables and the expected output.
</div>


can you please provide few rows from all the input tables and the expected output.

<div>
I was able to create a module that concatenated the results. Thank you!
</div>


I was able to create a module that concatenated the results. Thank you!

<div>
<div class="content wysiwyg-content">
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!
</div>
</div>


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!

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

A printer is a peripheral which makes a persistent human readable representation of graphics or text on paper or similar physical media. Traditional printers are being used more for special purposes, like printing photographs or artwork, and are no longer a must-have peripheral; 3D printing has become an area of intense interest, allowing the creation of physical objects. An image scanner is a device that optically scans images, printed text, handwriting, or an object, and converts it to a digital image. Hand-held scanners, where the device is moved by hand, have evolved from text scanning "wands" to 3D scanners used for industrial design, reverse engineering, test and measurement, orthotics, gaming and other applications.

Printers and Scanners

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.