iif statement in query criteria

evanhughes

Registered User.
Local time
Today, 13:51
Joined
Nov 26, 2009
Messages
46
Hi All

I need to show in a query costs of cleaning.

If [field] is L5 or L8 then it is 5 if [field] is P5 then it is 25 all other values are 55.

Evan
 
This is how you nest an IIF() statement
Code:
IIF([Field] = "something", [I]True part[/I], IIF([Field] = "another thing", [I]True part[/I], [I]False part[/I]))
See what you can come up with.
 
Hi All

I need to show in a query costs of cleaning.

If [field] is L5 or L8 then it is 5 if [field] is P5 then it is 25 all other values are 55.

Evan

IIF([FieldName]="L5",5,IIF([FieldName]="L8",5,IIF([FielName]="P5",25,55)))
 

Users who are viewing this thread

Back
Top Bottom