Access Query that brings up decimal amounts -


i'm working column of dollar amounts. have .00 @ end. want find amounts have cents in there , not .00

this have before, , don't know how should modify it. pulls .00

table1.amount "."

like works in text fields. need math solution amount-int(amount) < 0.001. needs more modification if amount can negative.


Comments