IIF alternative in query

[ChoonBoy]

I understand that using IIF expression in query can slow down the database.
Is there an alternative to the statement below as I have many IIF variants in
a single query.

Sales:
IIf([qty]="unit",[quantity],IIf([qty]="bonus",[bns],IIf([qty]="UnitBns",nz([quantity],0)+nz([bns],0),[Sale])))

Thanks in advance

 

[Dale Fye]

Take a look at the switch function. It will look something like:

Sales:Switch([qty] = "unit", value1, [qty] = "bonus", value2, [qty] =
"UnitBns", value3, True, 0)

You pass this function a series of expressions, each followed by the value
that should be returned if that expression evaluates to true. I generally
add a True, followed by some value that will indicate to you that none of the
expressions evaluated to true. If you don't do this, the function will
return a Null value.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[ChoonBoy]

Thanks, will try this out..

Regards

Take a look at the switch function. It will look something like:

Sales:Switch([qty] = "unit", value1, [qty] = "bonus", value2, [qty] =
"UnitBns", value3, True, 0)

You pass this function a series of expressions, each followed by the value
that should be returned if that expression evaluates to true. I generally
add a True, followed by some value that will indicate to you that none of the
expressions evaluated to true. If you don't do this, the function will
return a Null value.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

I understand that using IIF expression in query can slow down the database.
Is there an alternative to the statement below as I have many IIF variants in
a single query.

Sales:
IIf([qty]="unit",[quantity],IIf([qty]="bonus",[bns],IIf([qty]="UnitBns",nz([quantity],0)+nz([bns],0),[Sale])))

Thanks in advance