I want to bring data from 3 seperate tables into a single report in Access 2010.
Table 1 contains customer data, name address etc, Table 2 contains the financial aspects of the job, labour charges etc, and table 3 is a list of parts used on the job.
I have used a select query to get the information form each table onto the report, the tables are linked by the job number.
The problem I have is that if a job has been done and no parts were used, I don't get any information about that job on the report at all.
I guess I have not created the relationships properly or perhaps the grouping of the report is not correct, I tried to group by the job number but still get nothing if no parts were used.