Filter Percentages?

  • Thread starter Thread starter SKB
  • Start date Start date
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
 
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
 
Back
Top