Query with null fields

V

ValD

Hello: I need to run a query that displays information regarding
clients from three different tables each joined by a client id field.
The first table contains general info regarding the customer (address,
phone, etc.), the second lists workshops enrolled and completed, the
third displays referral details (date of referral, name of referring
organization). The query should display all clients whether they
enrolled in a workshop or not and whether they were referred to
another organization or not. The problem is when I run the query it
excludes any record that contains a null value for workshops and
referrals (thereby reducing the number of record from over 200 to 4).
Please help!
 
G

Guest

You need an Outer Join for this. Right click on the link between the tables
in your query and select the option:

Select All records in TableX and only those which match in TableZ (not the
exact wording but you should get the point).
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top