CODEWITHSUNDEEP
ms-access
JeepGirl
JeepGirl

Reputation: 21

Access Query that brings up decimal amounts

I'm working with a column of dollar amounts. They all have .00 at the end. I want to find amounts that have cents in there and not the .00

This is what I have before, and I don't know how I should modify it. This currently pulls up everything with .00

Table1.Amount Like "."

Upvotes: 0

Views: 30

Answers (1)

SunKnight0
SunKnight0

Reputation: 3351

Like only works in text fields. You need a math solution like Amount-Int(Amount) < 0.001. It needs more modification if your Amount can be negative.

Upvotes: 2

Related Questions