Expression used on form not working.

[bravura]

=IIf([Rate]<750, [Rate]*[Total_MT], [Rate]*([NbrOfD20Bkd] + [NbrOfD40Bkd]))

regardless if the Rate is over or under $750.00, form calculates (Rate * Total_MT).

Rate is stored in table as currency.




ideas?

Thanks.

[pbaldy]

Looks okay offhand. You aren't applying the format function or anything to Rate which might make it be seen as text? Can you attach the db here?

[John_G]

It wouldn't be because [NbrOfD20Bkd] + [NbrOfD40Bkd] = [Total_MT], would it? Is that possible?