IN

[brbarto]

Can I use IN in an if statement? If so, how?? How would be the best way to do the following?

If Me!VehicleNumber.Column(5) IN("820", "822", "824&quot And
[EndMileage] - [BeginMileage] < 1000 Then
Form!fsubPerMileCharge.Form![Quantity] = 1000
Else
Form!fsubPerMileCharge.Form![Quantity] =
[EndMileage] - [BeginMileage]
End If

Thanks (new to Access)

 

[ElGuapo]

Instead of using the IN operator use the OR operator.

If Me!VehicleNumber.Column(5)= &quot;820&quot; OR &quot;822&quot; OR &quot;824&quot; ...

Usually it is better to lookup the data in a table then typing it in into a funciton, but depends on the situation you have.

ElGuapo

 

[MichaelRed]

&quot;In&quot; is an SQL reserved word and NOT a VB function. MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over