Filter Percentages?

S

SKB

I have a field in a table with a rang of percentages. They are positive
and negative values. I want to filter for values greater than 1 and less
than -1. This is very easy in excel using the custom filter but, I can't
get it to work in access. I have tried <1 or >-1 for criteria in the
query but, it doesn't work. Is there anything special about filtering
percentages in access?

SKB
 
S

SKB

SKB said:
I have a field in a table with a rang of percentages. They are positive
and negative values. I want to filter for values greater than 1 and less
than -1. This is very easy in excel using the custom filter but, I can't
get it to work in access. I have tried <1 or >-1 for criteria in the
query but, it doesn't work. Is there anything special about filtering
percentages in access?

SKB
Click to expand...
I got it. Needed to be .01 and -.01 for the criteria.

SKB
 

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

Query Criteria Not Working 2
Problem Creating Totals Query 1
calculated field for percentage in pivot table 1
Calculate percentage 2
DCount function for filtered data in table 7
percentage of total froma query 10
query criteria Not Like ... <> 2
Calculating Percentages Using a Query 3

Top