Query Criteria of "whole number only"

[peskywinnets]

How do I set criteria of "show whole numbers only", so for example in this list

0.25
1
2.2
5
6.8
4


only the numbers 1 5 & 4 would be selected by the query? (with the rest being ignored)

many thanks!

 

[Ranman256]

in the query add a field:
IsWhole: [field]=int([field])

set criteria = true

 

[peskywinnets]

many thanks works a treat