Expression

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rciolkosz - 22 May 2008 15:18 GMT

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

Reply to this Message

fredg - 22 May 2008 15:37 GMT

> I have a column named Admin in a query, it's values are either "0", ".5" or
> values > .5
[quoted text clipped - 4 lines]
> 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]))

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

rciolkosz - 22 May 2008 16:18 GMT

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
[quoted text clipped - 6 lines]
>
> =IIf(Admin]=0,0,IIf([Admn]>0.5,[Admin]-0.5,[Admin]))

Reply to this Message