Select Integers only

[Cathy]

I have a field that has integer and non-integer data. For this one query, I
need to select out only the integer values. How do I make a query ingore any
value that has a decimal attached? (I don't need to round... I only want to
select the whole numbers.)

Thanks in advance for any help you can provide!
Cathy

 

[KARL DEWEY]

Set the criteria for your field like this ---
Int([YourFieldName])

 

[raskew via AccessMonster.com]

As I understand it, you don't want to include any value that includes a
decimal, e.g. 9.99 would be excluded, not rounded. If this is the case try
this as the criteria for your number field:

[YourFieldName]=Int([YourFieldName]

Bob

How do I make a query ingore any
value that has adecimalattached?

Set the criteria for your field like this ---
Int([YourFieldName])

More likely:

FIX(YourFieldName)

e.g.

SELECT INT(-9.99), FIX(-9.99)

returns -10 and -9 respectively.

Jamie.

--