Hello,
My name is Dan.  I work for a public school district.  I repair laptop computers for the students, teachers and staff.  I built my own database to keep track of what I do.  Im the only user of my database.  Ive been building this for the past 2 years and Ive got a database that Im very proud of.  
However, Im using cascading combo boxes to select parts needed to repair the devices but when I bring up my report showing how many devices are awaiting parts.  The 6 parts fields are showing the ID numbers and not the part names.
Ive watched many videos trying to find a solution.  The video of How to make multiple relationship joins to the same table.  It is the closest one Ive found to fixing my problem. But bringing the tables into the query only works 3 times.  I need it to work 6 times.
My solution was to make 2 queries, one for the first 3 columns of parts and the second query to handle the other 3 columns.  It works, but how can I get 2 queries into 1 report?
Ive tried doing a Union query.  That didnt work at all.
Ive tried dlookup.  That didn't work at all.
Ive even tried dragging and dropping my 2 queries into my report, but I didnt like it because it changed the layout and looked bulky and weird.
Any advice you could give would be much appreciated.