Between..And: How You Say It in VB????

[Kevin11]

Update to: IIf([ProductID] > 10 AND [ProductID] < 39, 0.50,
(IIf [ProductID]>39,1,0))

I think this should work.

Kevin11

-----Original Message-----
Here are the results I want in a syntax I am familiar

with (an update query, for example)

FieldName: QuantityDiscount
Update to: IIf([ProductID] Between 10 And 39, .50,IIf [ProductID] >39,1,0))

How do I say this in VB? I want these values to be set in

[QuantityDiscount] on Frm.Orders After Update on
[ProductID]