Need Help With a Query

[jukus]

I have attached a sample of data with the table I am working with.

What I am trying to get out of the query is this
From the table Invoice I want to get the field InvoiceID, DateofInvoice, Property, and BillingRate.

From the table Labor I want to get the total hours for each job tied to the Invoice ID

From the Table Purchase I want to get the total amount of purchases

My ultimate goal is to have a query that will show the InvoiceId Property and the toal amount of the Invoice.

I have tried several different things but I cannot get the results. It always seems to double the entries for the first invoice and skips number 2
and seems to look right for number 3. I have not even tried the calculations yet. If someone can point me in the right direction I would really appreciate it.

Thanks in advance.

 

[jukus]

I believe I have figured this out. I had to created three queries 2 which had outer joins to include null values and a third with the other fields I needed then I made a query based on the three and added the calculated fields.

My next question is how best to proceed. To my next step. Any advice is welcomed. If I want to take the info from the query to produce a report I can creat a form and base the form from the query and then make my report and everytime I run the report it make the query run (or at least I think it does). My question is, can you keep your form from have duplicate entries. If so how do you accomplish this.

Thanks in advance.