IIF statement evaluating for an integer

[Darrel]

I need to put this in Access query language. Any help is greatly appreciated.

IIf ( Left ( [INV-DESC] , 3)/5 = an integer , «truepart», «falsepart»)

(the left 3 digits of [INV-DESC] will be a whole number between 125 & 500)

 

[Clifford Bass]

Hi Darrel,

Try: IIf(CInt(Left([INV-DESC], 3)) mod 5 = 0, «truepart», «falsepart»)

Clifford Bass

 

[Darrel]

Works like a charm! I'll have to research CInt & mod to progress my
knowledge, but you sure saved me some time for now.

Hi Darrel,

Try: IIf(CInt(Left([INV-DESC], 3)) mod 5 = 0, «truepart», «falsepart»)

Clifford Bass

I need to put this in Access query language. Any help is greatly appreciated.

IIf ( Left ( [INV-DESC] , 3)/5 = an integer , «truepart», «falsepart»)

(the left 3 digits of [INV-DESC] will be a whole number between 125 & 500)