IIF statement evaluating for an integer

  • Thread starter Thread starter Darrel
  • Start date Start date
D

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)
 
Hi Darrel,

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

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

Clifford Bass said:
Hi Darrel,

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

Clifford Bass

Darrel said:
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)
Click to expand...
Click to expand...
 
Back
Top