Unexpected results, [Date] Is Null

[tina]

-----Original Message-----
In a secure Access 97 database, I set the criteria as
follows:

Field Name: Applied FMLA (Yes/No data type)
Criteria: Yes
Field Name: FMLA Approved Date (Date data type)
Criteria: Is Null

Or Criteria
Field Name: Applied FMLA (Yes/No data type)
Criteria: Yes
Field Name: FMLA Denied (Yes/No data type)
Criteria: No

I want to see records where Applied FMLA = Yes, and FMLA
Approved Date is Null, Or FMLA Denied = No. The results
are including records where the FMLA Approved Date field
Is Null.

Everything else in the database seems to be working
fine. I repaired and compacted earlier this week.

Any suggestions? Is there something wrong with the
criteria?

Thanks,
Mary

.
access is doing EXACTLY what you told it to do, as

SELECT AppliedFMLA, FMLAApprovedDate, FMLADenied
WHERE (AppliedFMLA=Yes AND FMLAApprovedDate Is Null) OR
(AppliedFMLA=Yes AND FMLADenied=No)

not sure what you're after, because one of your stated
criteria is "FMLA Approved Date Is Null", but your concern
seems to be that "The results are including records where
the FMLA Approved Date field Is Null."

???

 

[Mary]

Sorry, I meant to say Access is including records where
that date is Not null. The FMLA has been approved, but
it's still showing up in this query. I don't want to see
those records.