Select Integers only

[Guest]

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

 

[Guest]

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

 

[Jamie Collins]

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.

--

 

[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.

--

 

[Jamie Collins]

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]

On reflection, I think your are probably correct that the OP wants to
apply a search condition (i.e. WHERE clause) rather than perform a
data transformation (i.e. SELECT clause), in which case INT and FIX
will work equally well

Jamie.

--