Doubled Results--still need help pls!!!

[Andy]

I almost forgot, another problem that may be related:
when one data table has entries for a certain account but
another data table in the query does not, it returns NO
results for either table. It SHOULD give a sum of 0 for
the table that doesn't include the referenced account
number and the correct sum for the one that does, but it
just excludes that reference account from the query
results entirely. This is also a problem I started having
after the upgrade to 2002.

 

[Michel Walsh]

Hi,


You should use an outer join rather than an inner join. When you use an
inner join, and there is no match in the other table, the unmatching record
is stripped out of the result. With an outer join, one of the table involved
in the ON clause is preserved, even if there is no match. From your
description, it seems this is what you need.


Vanderghast, Access MVP