Joining Tables in a Query and Null Values

[DrDirtyDog]

I really need advice on this problem, as I am not sure if it is a fault with my Database or Access itself. I run the query with one table and fine I get the full membership list I need 4280 members and details etc. If I run the query with two joined tables (tblMember and tblSubpayment)I get less 3980. I figure this is to do with Null Values and the joined tables will not show this. But is there anyway I can show these values and still have 4280 members with all payment details by running two tables in my query? I work in Membership so it is important for me to be able to do this. If anyone out there could answer this I would be very grateful.

 

[mwolf00]

You need to change the join properties. If you are using the query builder, right click on the line joining the two tables and select "Join Properties". Select one of the three radio buttons to suit your needs.... Get the Best Answers! faq333-2924
"A witty saying proves nothing." - Voltaire
mikewolf@tst-us.com

 

[annsolomon]

DrDirtyDog, Mike is right. The default join is the first option (only include records where the joined fields are equal). It sounds like what you want to choose is All records from tblMember and only those records from tblSubPayment where the joined fields are equal.