query to find numbers with decimals

[kam6]

Hello - I am trying to create a query using Microsoft Query to find numbers that have decimals (236.4, 598.1, 678.5, etc)

These numbers are in an Access database under a column called "Quantity".

I just need to know what Criterias should I use to filter when I have the database opened in Microsoft Query.

Thanks in advance


Carlos

 

[Pat Hartman]

In the criteria cell for YourField, put:

Int(YourField)

The Int() function converts a field to an integer. If the integer value is the same as the original value, there were no decimal digits.

 

[kam6]

integer query question

Thanks for your advice Pat! It works, but it only shows the whole numbers (integers) on the field. The numbers with decimals are excluded... What I want to show is the opposite: the numbers that have decimals.

What could be the name of the function to show the numbers with decimals only? I tried "nonint(YourField)" and "dec(YourField)", none worked.

Advice is appreciated - Thanks!


Carlos

 

[kam6]

"float" command?

Pat - I was just checking out a book here at home, which talks about numbers being "integers" and "floats":

- Integers being whole numbers;

- Floats being numbers with decimals;

As I mentioned, the function that you indicated - Int(YourField) - shows the Integers (whole numbers) on the column;

What could be the function to show the Floats on the column?

Just to try I wrote "Float(YourField)", it didn't work, what could be the proper syntax?

Thanks in advance


Carlos

 

[Rich]

Not Int([YourField]) in the criteria

 

[kam6]

It works!! Many thanks for your advice on the syntax, Rich!


Carlos