Filter out values of £0.00 in a query

A

Astrid

Just a quick one (hopefully),

I have a query with prices that I need to filter. I have already filtered by
"Is Not Null" to remove any blank fields. I also need to filter out a few
records with values of £0.00, and I have tried the following;

Is Not Null AND <0 (doesn't filter out £0.00 records)

Is Not Null AND NOT "£0.00" / Is Not Null AND <£0.00 (displays 'Data type
mismatch in criteria expression')

I have tried entering the above into one or two criteria fields and no joy.
Can anyone give me a clue as to where I'm going wrong?

Many thanks,

Astrid
 
J

John Spencer

You should be able to do that with just criteria of
<> 0
that should filter out nulls and zeroes. No need to test specifically for
nulls in this case.

< 0 would filter out negative numbers out, but not 0. You need either <= 0
or <> 0 to do that.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Parameter Crosstab query filter by form 1
Blank Fields in NOT Null Query Criteria 5
IIF statement 6
Report query / filters 2
Parameter Query to filter dates as entered in and if not to show N 4
Append Queries - Seek Old Invoices 2
Filter query so the only records displayed have 4 null fields 2
Criteria not excluding data 2

Top