Report based on Query when not all records match

[ronphx]

I have a report that prints an invoice. It is based on a query that has several tables, but the problem lies with the following two tables: tblinvoice and tblship (tblship is a table which contains a ship to address that is different from the billing address). Not all invoices have a separate shipping address, so not all records in tblinvoice have a corresponding record in tblship. When I tried to set up a query behind the report, for those invoices without a ship to address, there were was no record brought up by the query. Does anyone know how to include the ship to address only when it is present?

Thanks.

 

[dawnd3]

Hi there, easy solution Just double click on the line between the two tables in the query design and change the join type. You probably want "show all records in tblInvoice and only the records in tblShip that match." Something like that...

Dawn

http://www.calliopeconsulting.net

 

[ronphx]

Perfect. Thank you so much.