Maximum number query

[charles.gallegos2]

I have a list of values that I want to change to have a maximum of 100.
For example, if the value is 330, the result should be 100. If the
value is 50, the result should be 50. And so on. Any ideas? Thanks in
advance. I appreciate any help you can give me! Thanks.

 

[raskew via AccessMonster.com]

Hi -

Try the Iif() function:
x = iif(y>100, 100, y)

HTH - Bob

 

[charles.gallegos2]

Thanks- that worked great!

Hi -

Try the Iif() function:
x = iif(y>100, 100, y)

HTH - Bob

 

[charles.gallegos2]

Thanks- that worked great!

Hi -

Try the Iif() function:
x = iif(y>100, 100, y)

HTH - Bob