IIF in query

[samotek via AccessMonster.com]

I have the following expression in my query :
Expr1: [ddu]*[size]*[Quantity]

Can you hlp me build an IIF with the following condition :

If size < 1 then [ddu]*[size]*[Quantity]"2
else
[ddu]*[size]*[Quantity]

 

[raskew via AccessMonster.com]

Hi -

Not sure what the "2 represents -- it needs to be clarified.

Expr1: Iif([size]<1, [ddu]*[size]*[Quantity]"2, [ddu]*[size]*[Quantity]
)

HTH - Bob

I have the following expression in my query :
Expr1: [ddu]*[size]*[Quantity]

Can you hlp me build an IIF with the following condition :

If size < 1 then [ddu]*[size]*[Quantity]"2
else
[ddu]*[size]*[Quantity]