Identify Non-Even Dollar Transactions

S

StephanieH

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?
 
A

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

StephanieH

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

Works perfectly.

Thanks again.

Allen Browne said:
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.

StephanieH said:
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?
Click to expand...
Click to expand...
 
Top