IIF true, multiply a field by 2

[ryguy7272]

Goal: IIF([ID]="liz",[C1 Display - Q408]*2,[C1 Display - Q408])

Access is telling me that I am 'executing a query that does not include a
specified expression'.

Basically, I want to say, if the ID is liz, multiply her goal by 2, else
just give me the goal. This function is in the Field line. Table, Total,
Sort, etc. are all blank... What am I doing wrong?

Thanks,
Ryan--

 

[Golfinray]

IIF([id]="liz",([c1 display-q408]*2),[c1 display-q408])

 

[ryguy7272]

Ah! It is pretty easy when you know what to do...
Thanks for shedding some light on the subject!

Regards,
Ryan---


--
RyGuy

IIF([id]="liz",([c1 display-q408]*2),[c1 display-q408])

Goal: IIF([ID]="liz",([C1 Display - Q408]*2),[C1 Display - Q408])

Access is telling me that I am 'executing a query that does not include a
specified expression'.

Basically, I want to say, if the ID is liz, multiply her goal by 2, else
just give me the goal. This function is in the Field line. Table, Total,
Sort, etc. are all blank... What am I doing wrong?

Thanks,
Ryan--

 

[John Spencer]

If that was sarcasm, then you still need an answer.
If that was not sarcasm, then congratulations on your ability to make sense
out of the reply.

If you still need help, please let us know.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County