Filtering in a Query

[Guest]

In a query, I would like to filter out all whole numbers in a field and only
leave the records with fractions, which could be one decimal place or upto
seven decimal places.

TFTH,
Tom

 

[Douglas J. Steele]

WHERE Int([MyField]) <> [MyField]

 

[Guest]

Not sure how to intergrate this into the query (Where and How)? Please
simplify for me, as I am not as up on Access as I should be.
TFTH,
Tom

WHERE Int([MyField]) <> [MyField]


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

In a query, I would like to filter out all whole numbers in a field and
only
leave the records with fractions, which could be one decimal place or upto
seven decimal places.

TFTH,
Tom

 

[Douglas J. Steele]

If you're using the graphical query builder, add a computed field in the
grid by typing

Int([MyField])

in "Field" row of an empty column.

In the "Criteria" row of that same column, type [MyField]

(replace both occurrences of MyField with the actual field name, of course)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Not sure how to intergrate this into the query (Where and How)? Please
simplify for me, as I am not as up on Access as I should be.
TFTH,
Tom

WHERE Int([MyField]) <> [MyField]


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

In a query, I would like to filter out all whole numbers in a field and
only
leave the records with fractions, which could be one decimal place or
upto
seven decimal places.

TFTH,
Tom

 

[Guest]

Douglas,
Worked great except it returned the whole numbers. I really am wanting the
query to return numbers that are fractions. Any ideas?

If you're using the graphical query builder, add a computed field in the
grid by typing

Int([MyField])

in "Field" row of an empty column.

In the "Criteria" row of that same column, type [MyField]

(replace both occurrences of MyField with the actual field name, of course)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Not sure how to intergrate this into the query (Where and How)? Please
simplify for me, as I am not as up on Access as I should be.
TFTH,
Tom

WHERE Int([MyField]) <> [MyField]


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


In a query, I would like to filter out all whole numbers in a field and
only
leave the records with fractions, which could be one decimal place or
upto
seven decimal places.

TFTH,
Tom

 

[Douglas J. Steele]

Make sure you're returning [MyField], not Int([MyField])

To make it easier when looking at the query, uncheck the box in the "Show"
row of the computed column you added.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Douglas,
Worked great except it returned the whole numbers. I really am wanting
the
query to return numbers that are fractions. Any ideas?

If you're using the graphical query builder, add a computed field in the
grid by typing

Int([MyField])

in "Field" row of an empty column.

In the "Criteria" row of that same column, type [MyField]

(replace both occurrences of MyField with the actual field name, of
course)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Not sure how to intergrate this into the query (Where and How)? Please
simplify for me, as I am not as up on Access as I should be.
TFTH,
Tom

:

WHERE Int([MyField]) <> [MyField]


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


In a query, I would like to filter out all whole numbers in a field
and
only
leave the records with fractions, which could be one decimal place
or
upto
seven decimal places.

TFTH,
Tom