Null means "nothing there". Is part of the problem because you are trying
to compare to "nothing there"?

If you'll post the SQL statement of your query, the folks here would have a
few more clues to go on...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Lars Brownie" <lars@brownie.com> wrote in message
news:g689fl$c1u$1@textnews.wanadoo.nl...
>I have a query with criteria in 2 fields:
> FieldA has criteria: [forms]![MyForm].[Field1]
> FieldB had criteria: [forms]![MyForm].[Field2]
>
> So I need an exact match on those 2 fields.
>
> Field1 is never null but Field2 can be null. If Field2 is null then the
> query should look for the Field1 criteria in FieldA AND for a null value
> for FieldB. However, this is not working, I get no results. When field2 is
> not null, it does work.
>
> Can someone help me out?
> Thanks, Lars
>