M
Milan
I will reply in general:
A query returns too many records usually if the links
between the tables are too loose (single field link
instead of double etc.).
A query returns fewer records than expected for a lot more
reasons. This time the links could be too strong (linking
fields that don't really match). Nulls are especially a
problem as Null is never matched to another Null.
Where clause could also contribute to fewer records. Also
Null, empty string (""), " " are all different values,
Null is not equal to anything. There could be data
conversion issues too (0 is different from "0" etc.)
Start by defining properly your links and then add one by
one condition in the where clause and observe the records
returned.
Milan
A query returns too many records usually if the links
between the tables are too loose (single field link
instead of double etc.).
A query returns fewer records than expected for a lot more
reasons. This time the links could be too strong (linking
fields that don't really match). Nulls are especially a
problem as Null is never matched to another Null.
Where clause could also contribute to fewer records. Also
Null, empty string (""), " " are all different values,
Null is not equal to anything. There could be data
conversion issues too (0 is different from "0" etc.)
Start by defining properly your links and then add one by
one condition in the where clause and observe the records
returned.
Milan