Help with Expression builder

B

Bruce

This is my first time here and hope someone can help me. I'm trying to
multiply a field by a number, now that in it's self was easy. But depending
on the numbers value it needs to be multiplied by a different number. This
is what I have so far:
Expr1: [invd_units_ext]*0.04 but if [invd_units_ext] is 0 to 999 it needs to
be multiplied by 0.04 but if it is 1000 to 9999 it needs to be multiplied by
0.03.

Any help with this would be greatly appreciated.
 
R

r. howell

See if this works: Expr1:
IIf([invd_units_ext]<1000,[invd_units_ext]*0.04,[invd_units_ext]*0.03)

Check it, because I'm no expert
 
Top