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?

Answer

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

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