Criteria on % field

  • Thread starter Thread starter Patty
  • Start date Start date
P

Patty

I am creating a significant variances report. I have a field that calculates
the % change. How do I limit my query to records with a significant change
like < 50% or > 50%?
 
Patty,
Although a value may display as 50%, the actual stored value will be .5.
And, if you use the criteria you showed, you'll miss any value that
equals 50%
So... choose one of the following criteria...
<= .5 or > .5
or
< .5 or >= .5
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
The first calculated field is the "difference". When I try to use the
formula that you recommend, I get the "Enter Parameter Value" window for the
"difference" field. If I choose okay, no records are returned. One more
thing, I limit the "difference" by those < -500 and > 500. Taking this
criteria out the the "difference" field does not produce different results.
 
Patty
Please describe in detail the fields that are used in this calculation.
Names, calculations, and criteria/s... and sample values.

Enter Parameter Value usually signifies that you have a name, or term in
the calculation that Access does not recognize.
This criteria will return no values. No number can be less than -500
AND greater than 500.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top