IIF true, multiply a field by 2

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

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--
 
Ah! It is pretty easy when you know what to do...
Thanks for shedding some light on the subject!

Regards,
Ryan---


--
RyGuy


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

ryguy7272 said:
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--
Click to expand...
Click to expand...
 
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
 
Back
Top