Doubled Results--still need help pls!!!

  • Thread starter Thread starter Andy
  • Start date Start date
A

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.
 
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
 
Back
Top