Testing for an integer

[NH]

What is the simplest and most effective way of testing whether or not a
number is infact an integer or not.

Is there a built-in function?

In Excel I would compare it to the Floor() of itself, but I am not sure with
Access...

Thanks

Nick

 

[NH]

Ignore that. I wasn't thinking.

I compared it to Cint() of itself..

 

[Mike Sherrill]

What is the simplest and most effective way of testing whether or not a
number is infact an integer or not.

The answer turns on what *you* mean by "is in fact an integer".

Is a Long Integer an integer? Is the Double value 32.0 an integer?
Is the string "32" an integer? You might want to look at help for the
functions VarType(), TypeName(), and Int().