View Full Version : Currency Problem, Displaying without decimal places

12-08-2004, 12:52 AM
Hi I'm pretty new to ASP, and trying to learn it gradually.

I have an ecommerce site using an Access database.

It extracts the products through the ID numbers, as well as the prices.

Everything else is working fine, but the only problem I see to encounter, is that when I save a price as 94.00, it displays in the page as 94... and for example 12.10, that would become 12.1.

I need to try and sort this out, I have been trying to work it out for a few weeks, on and off, and really have come to a blank.

I tried using the round feature with the 2 decimal places, command, hoping it would display as that, but still no luck.

I got the price set as currency in access database, and 2 decimal places, but I'm sure the problem lies in the asp extraction process from the database.

Also a relating problem, I have 2 prices in the database, one ex vat, and one inc vat, I need the ex vat table to automatically work out the ex vat price from the inc vat table, I know you have to use an expression builder,but after hours of fiddling, still stuck on square 1.

I need the "ex vat" table to get the price from "inc vat" table and divide it by 1.175, thats all...

Any help would be greatly appreciated, if I need to post any code, please just say and I will asap.

Thanks a lot :thumbsup:


12-08-2004, 03:52 AM
Use FormatNumber() (http://www.devguru.com/Technologies/vbscript/quickref/Formatnumber.html). You can also use FormatCurrency() (http://www.devguru.com/Technologies/vbscript/quickref/formatcurrency.html) but the currency symbol used is I think the symbol set in the currency settings in the Regional Options of the server. If is set as the symbol then use FormatCurrency. But if you don't want to depend on the server settings, use FormatNumber.

12-08-2004, 04:03 AM
Thanks for that mate,

I'll give it a go, and hopefully it'll sort my dilemma.

Thanks again.


12-08-2004, 04:12 AM
Thanks again buddy, had to modify it slightly because the query came from an access database.


Thats what worked, and will continue to use :thumbsup:

Thanks again, your a life saver (and time saver)