iif statement

[why_me143]

hey
im creating a hotel booking system on microsoft access and i would like to
use an IIf statement on my report to work out a discounted cost for recurring
customers
so far i have manage to create a iif statement but that shows the formula
instead of the value
i have two unbound text boxes and have put:

=IIf([Promotions?]=True," «Expr» [Text56] «Expr» "," «Expr» [Text54] «Expr»
")

Text56 is =[text41]*0.9
Text 54 is =[text41]
with text 41 being the total cost


can anyone help ?

 

[H. Druss]

hey
im creating a hotel booking system on microsoft access and i would like to
use an IIf statement on my report to work out a discounted cost for
recurring
customers
so far i have manage to create a iif statement but that shows the formula
instead of the value
i have two unbound text boxes and have put:

=IIf([Promotions?]=True," «Expr» [Text56] «Expr» "," «Expr» [Text54]
«Expr»
")

Text56 is =[text41]*0.9
Text 54 is =[text41]
with text 41 being the total cost


can anyone help ?

Hi
should be:

Result = Iff(Expression,True Part, False Part)

Good luck
Harold

 

[BruceM]

It looks as if you used the (wretched) expression builder. «Expr» is a
placeholder. It cannot be part of the expression. You may need to use the
expressions directly rather than referencing Text56 and Text54:
=IIf([Promotions?]=True,[Text41]*0.9,[Text41])

If Text41 is a calculated control you may need to substitute the expression
for the text box name.
Consider giving text boxes, etc. useful names rather than the default names.
For instance, txtTotal instead of Test41.