show even records with no info in some fields

[cbiker]

I have a qry that pulls info from 3 tables linked by date but sometimes the loads table wont have info for that date when that happens that dates information wont show but I still need the info from that dates other to tables to show how do I accomplish this.
Any help will be appretiated.

 

[scriverb]

This is a duplicate posting. See thread: thread701-817677 for the answer to this thread.

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