Criteria in Query (1 Viewer)

[dougbnv]

Hi there,

I have a field that shows numbers in a query, What I want to do is if the value of the number is greater than 200 I want to show it as 199.

Does that make sense?
Is there a way to change the number in the criteria field, I know you can show records >200 and <200 but can I say if the number is >200 then show 199?

Any help would greatly appreciated.

 

[David R]

In the query field:
Iif([Field]>199, 199, [Field])

 

[dougbnv]

Thanks David R - That worked perfect.