Expression

[rciolkosz]

I have a column named Admin in a query, it's values are either "0", ".5" or
values > .5

In the expression I would like to return the "0" as "0", and if the value is

.5 I would like .5 subtracted from the >.5 value.

ex., say the value is 1.5, in the expression I would like to subtract .5
from 1.5 and return a value of 1.0

 

[fredg]

I have a column named Admin in a query, it's values are either "0", ".5" or
values > .5

In the expression I would like to return the "0" as "0", and if the value is

ex., say the value is 1.5, in the expression I would like to subtract .5
from 1.5 and return a value of 1.0

=IIf(Admin]=0,0,IIf([Admn]>0.5,[Admin]-0.5,[Admin]))

 

[rciolkosz]

I have been trying, cannot get it.

I have a column named Admin in a query, it's values are either "0", ".5" or
values > .5

In the expression I would like to return the "0" as "0", and if the value is

ex., say the value is 1.5, in the expression I would like to subtract .5
from 1.5 and return a value of 1.0

=IIf(Admin]=0,0,IIf([Admn]>0.5,[Admin]-0.5,[Admin]))