CODEWITHSUNDEEP
sqlms-access
YvetteLee
YvetteLee

Reputation: 1090

MS Access SQL - Find numbers with decimals no end to Zero (,00)

I am having a table and i would like to find all numbers where it doesn't end to ,00 but with decimal number like ,01 or ,23 or etc...

My Table Data              Desire Output

id     s                  id     s      c
 1   32,00                 1   32,00   NULL
 2   13,13                 2   13,13  13,13
 3   55,05                 3   55,05  55,05
 4   76,00                 4   76,00   NULL

I would like to create a sql query to create column c like

iif(s IS ZERO AFTER DECIMAL, NULL, s)

Is it possible in MS ACCESS SQL?

Upvotes: 0

Views: 145

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1270713

For positive numbers, you can use floor or int():

iif(s <> int(s), . . .

Upvotes: 1

Related Questions