criteria

[Guest]

I am trying to create a filter in my Access query by a field called
'Purchase'. The possible values in the field are 'p' and null only. I want
only those records which have a value not p that is null. I am also using a
'totals' row in the same query. To create the filter,
i have used
'not "p".
I have also used in the criteria box <>p.
They dont work, can someone tell why not.
The only thing that works is filtering by 'Null'

 

[TPratt]

I've found that by adding a value in the criteria field you can
automatically eliminate Null values...unless you specify that you want to
see them.

Try in the criteria box...
<>"P" or Is Null
or just...
Is Null