asked on IFF expression
Why is only the first part working on this? This only subtracts 5% from all prices.
Iff([DatePosted]>3/4/2012,
I appreciate your help.
Iff([DatePosted]>3/4/2012,
I appreciate your help.
Microsoft Access
Last Comment
Dale Fye
ASKER
the #'s prompt me for a date. [DatePosted] is the date, so I should not be getting a prompt.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
It worked great. Thanks.
which one ?
I'm assuming you guys meant IIF( ) not IFF( )
;-)
You could also have used:
[Price] * (1-iif([DatePosted] > #3/4/2012#, .05, .03))
;-)
You could also have used:
[Price] * (1-iif([DatePosted] > #3/4/2012#, .05, .03))
Iff([DatePosted] > #3/4 /2012#, [Price] - 0.05 * [Price], [Price] - 0.03 * [Price])
mx