Identify Non-Even Dollar Transactions

[Guest]

My (table) field is formatted as currency (Decimal places set to "Auto").
I'd like my query to filter all non-even dollar transactions ie: $65.55 but
not $65.00

I've tried Not Like "*.00" and Not Like "$*.00" but neither work.

What am I missing?

 

[Allen Browne]

Enter something like this into the Field row in query design:
[MyField] - Int([MyField])

In the Criteria row under this, enter:
<> 0

Explanation:
Int() gives the whole number value.
The difference will be non-zero if cents exist.

 

[Guest]

Thank you for including both the answer and the explanation. That really
helps.

Works perfectly.

Thanks again.

Enter something like this into the Field row in query design:
[MyField] - Int([MyField])

In the Criteria row under this, enter:
<> 0

Explanation:
Int() gives the whole number value.
The difference will be non-zero if cents exist.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

My (table) field is formatted as currency (Decimal places set to "Auto").
I'd like my query to filter all non-even dollar transactions ie: $65.55
but
not $65.00

I've tried Not Like "*.00" and Not Like "$*.00" but neither work.

What am I missing?