Yes, it should filter it out, though there could be something else in the
WHERE clause that is affecting it.
For example, if you have:
WHERE (Company Is Null) OR (Amount > 0 AND PayOffDate Is Null)
any record where the Company field is null will be returned, regardless of
the date. That's becuase of the way the OR and AND are bracketed.
In summary:
A OR (B AND C)
is not the same as:
(A OR B) AND C
If that is not what is happening, try a repair on your database. If the
PayOffDate field is indexed, a corrupt index can give the symptoms you
describe.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<jn********@gmail.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
I have a Access 97 query that has in its where clause:
And ((tbl_01_LoanData.PayOffDate) Is Null)
Upon execution, all records returned have no PayOffDate except 1. When
I include PayOffDate in the select list one record shows a date of
'12/16/2005' - clearly not a null value. Shouldn't the above code
filter this out? Many thanks!
-Jeff