Date relationships between linked tables 1

[Wrecker]

I have a database with several linked tables from other databases. The relasionship I used is the Date. What I would like to do is be able to query on a date, and bring back the data from each linked table. The problem I am having is if I query on a date it brings back Data only if there is data in all of the tables for the specified date. I need it to bring back data even if ONE of the tables has no data for the specified date.

Trying to learn.....
Thanks
Wrecker

 

[KenReay]

Hi

Sounds like you need to use left of right joins, in your query design view, right click the join and set the chracteristics of the join accordingly Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK