Switch query

[Guest]

I am trying to write a query where the sum can = different variables for
example
if salary*6.25 is <5800 then salary*6.25=salary*6.25, if salary*6.25 is

=5800 then salary*6.25=5800.

Can someone help?

 

[Guest]

THANK YOU THANK YOU!

Try yhis
iif ((salary*6.25)>=5800,5800, salary*6.25)