display empty fields in qry 1

[cbiker]

I have a qry with 3 tables in it all linked by date. The problem is that sometimes the table for Loads can be blank for the day so in the qry that day wont show in qry but I still need to see the rest of Info for that day. how can I fix this.

 

[scriverb]

The relationships established either at the database level or at the query level have to be left joins for the record to row to be included even though one of your tables has no matching record. Of you three tables the one that is driving your query should have joins between that table and the connecting table that has an arrow that points to the connecting table by the date field. This join is considered a left join. It displays the row of the primary table even though there is no matching record in the secondary connecting table. This type of join should also be used for the third table as well. This way you will get a row for each record in your primary table even though their may be no record in either of the connecting tables.

Post back with your SQL if you would like me to modify it for you.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[cbiker]

Sorry about the multiple posts They seem to be disapering when I come back to look at them they dont seem to be here so I thought I did something wrong and re posted. Thanks for the Help.