I am trying to print an invoice report for a customer who has had service performed on his/her car. the query may be more complicated than it needs to be, but I have enclosed the query and all of the associated tables. When I run the query, it appears as if numerous copies of each record are being displayed, and when I add tblParts, which I need, the query does not return any records. When you open the Query design of 'Copy Of rptInvoice Backup query' you will see that I have not added tblParts.
I need assistance with two issues relative to this query:
1. Why is it returning multiple copies of the same record?
2. Why does it not return any records when tblParts is added?
BTW, I need to add the field named 'Part' to the query from tblParts.
Thanks in advance for the assistance.