Your problem is in the nature of what's called an "inner join" - you are
probably linking the output from both queries via CustID, and by default the
Query Designer makes such joins "inner joins" ie. it only shows records where
there is an exact match in both of the queries. If there is a CustID in one
query but not in another - in your case, if someone has Dues owing but not
made any payments - they aren't going to appear.
To see those people, you need to change the inner join to an outer join - so
that it shows all of the records from one table, irrespective of whether they
have a match in the other table - and the records from the other table that
have matches in your first one. Outer joins can be Left Outer Joins or Right
Outer Joins, but that's just a matter of the order that you specify your
tables in. You can change the join type in Query Designer by right clicking
on the line that represents the join and choosing from the subsequent message
box.
Note that this outer join will show you all customers who have Dues and any
payments they may or may not have made. If there is the possibility of
customers making payments when they don't have anything due, the outer join
isn't going to show this. If this is possible, it gets a bit more complicated,
but is still possible.
Hope that helps.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200511/1