Join question

[wizcow]

My Invoice form has a sub form for 'Products' and
also a sub form for 'Practitioner Visits'

I am trying to get the data from these two subforms into one query.

I have buildt a query that has the 'Invoice Products' table and the 'Invoice Practitioner Visits' table.

I am trying to join them with the comon 'InvoiceNo' field.

How do I join these two tables so they will return data, even if one of the tables is empty? Keeping in mind that either table could have a null value.

Thanks
Tom

 

[mkelly]

did you try a union query from the data in the tables?

 

[wizcow]

I was hoping you wouldn't say that.

Back to the Report drawing board.

Thanks for the help!

Tom