Access Value Change 2

[dutchess]

I am trying to limit my query to 100%, Some of the values are greater than 100% and I would like to have anything that is over 100% return a value of 100%.

Example: Judy 111% adherence would equal 100%

Thank you for any advice!!

 

[dhookom]

Do you have a field name? Is this a calculated or stored value? Is this a text field or numeric?
You might be able to use:
NewYourField:IIf([YourField]>1,1,[YourField])

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[dutchess]

Thank You, I was using a 100% value instead of 1!!!!