Using Query to find numbers that end in "0.00"

[BrockWade]

I'm trying to write a query that only shows numbers that end in "0.00" e.g. 360.00, 100.00, 150.00, 60.00, etc.
I'm using this simple query:



SELECT qryUnmatched.Store, qryUnmatched.Amount
FROM qryUnmatched;

I was thinkin g too about using "trim":

SELECT qryUnmatched.Store, qryUnmatched.Amount
FROM qryUnmatched
WHERE (((Right(Trim([qryUnmatched].[Amount]),3))=CStr("0.00")));

I know my syntax is probably wrong here

but I need to add WHERE clause possibly using the MOD function to find those numbers... any clues? Thanks!!!

[Dal Jeanis]

You have a couple of options, and I'm not sure which one is the most efficient. I suspect the second one is.

WHERE Right(Format([qryUnmatched].[Amount],"0.00"),4)="0.00")

The format gives you at least three numeric digits plus the decimal point, so the comparison should work correctly.

WHERE ( ([qryUnmatched].[Amount]) = 10*INT(([qryUnmatched].[Amount])/10) )

The 10*INT(X/10) leaves zeroes in the ones place and the decimals, so it will only equal X if those digits were previously zero.

[June7]

Amount is a double number field? Access does not save the point and zeros when the decimal is zero.
So Amount has been converted to a text string with Format function?

Trim not needed.
WHERE Right([Amount]),3)=".00"

There are other possible manipulations but that one seems to accomplish.