Test for whole number

[Guest]

Hi,

Can anyone tell me what function I can use to test whether a number is whole?

Thanks in advance.

Jedster

 

[Van T. Dinh]

If Int(YourNumber) = YourNumber Then
' It is a whole number

 

[Michel Walsh]

Hi,


CBool( int(x)=x )



Hoping it may help,
Vanderghast, Access MVP