I have a table like so:
The JobID and TechID are pointed to the primary keys of there respected tables with relationships. I would like to show these 3 fields (all with the same job and employee) on one report. But when I pull up the report with the JobID i want to look at, each field is on it's own page. Is there anyway I can show all this on one page? Should I use VBA, and run the query myself?Code:[JobID] [TechID] [PartsUsed] [Hours] 1 2 Part 1 4 1 2 Part 2 5 1 2 Part 9 30
Thanks