Exclude non-integers in my query

[BJF]

Hi,

I need to exclude non-integers in my query and have forgotten how to do this.
Can anyone help on what i need to put into the criteria field within my query to to this?

Thanks for any suggestions

 

[MarkK]

Round() or Int() or CInt() or CLng() or Fix() the number and subtract it from the non-rounded value. If the result is zero then the rounding had no effect and the orig value had no decimal portion.

 

[BJF]

i'LL TRY THAT MARK, THANKS!