Access SQL INT function

Question

I'm trying to extract some numbers with decimals but need to remove the decimal part. There's no fixed length on any of both sides.

I have already tried:

INT()
INTR()
ROUND()

Usually INT() should solve this but sometimes it doesn't return the correct number (for example, INT(3) returns 2).

Could you give a more concrete example of INT(3) returns 2? – Frode Nilsen Apr 08 '16 at 08:13 — Frode Nilsen, Apr 08 '16 at 08:13

score 0 · Answer 1 · edited May 23 '17 at 10:33

0

Did you try the function TRUNC(number, [, decimal_places]) ?

EDIT

For the round precision you can see this link

edited May 23 '17 at 10:33

Community

answered Apr 08 '16 at 08:14

Till

Yeah I tried, but an error telling me that the function is not defined within the expression pops up. – bbbb Apr 08 '16 at 08:16
You could try : `ROUND(column_name * 1000000, 0)` like the link I updated. – Till Apr 08 '16 at 08:20

score 0 · Answer 2 · answered Apr 08 '16 at 08:32

0

I ended up solving it on my own! ROUND didn't work and FLOOR was also undefined...

I ended up needing to use two INTs with a FORMAT in one of them.

Thank you anyway.

answered Apr 08 '16 at 08:32

bbbb

2 Answers2