View Full Version : Decimal Places with Access 2000

14-06-2002, 12:50 PM

I'm using an Access 200 Database to run my website. I multiply a figure of 2dp by a figure of 1dp, then 3dp to get the final number. This leaves me with a number of anywhere between 0 and 8dp. However, I want to have no dp at all.

Eg, I want my figure to look like 1647, rather than 1647.472435

I know that I can crank back the number of decimal places to 0 in the properties window under query design view, but this only affects the number that is displayed in the query datasheet view, and when I call it on my webpage it displays all digits.

The numbers being multiplied are all in 'Currency' format, and the webpage in question uses ASP.

Appreciate any help...


14-06-2002, 03:40 PM
Have a look at the ROUND() feature in Access

14-06-2002, 03:48 PM
Or the cint() function (convert to integer)

14-06-2002, 06:07 PM

It seems like I shouldn't have been so hasty to admit defeat, as after a little more poking around on the internet, I managed to figure out how to use the Round() function, and have use it in my page, rather than in Access itself.

How does one implement it in Access?

And also, what uses does CInt() have?