I'm building an economic siyte that compares currency values from all over the world. These are stored in a database table. Right now the site does comparisons between three countries (US, Canada and Mexico) to the country selected. Things are working well right now.

However, the client now wants to move this to the next level which is to let the user select the three countries a currency will be compared to. Generally, there is no problem. However, certain countries (ex. Turkey) have such a low value that any data displayed has an exponential on it such as 2.337645E05

How do I ensure that the exponential is not diaplayed without creating an overflow? I need it to display 0.00002337645 instead of 2.337645E05 because the next formula on the page is calculating the percent increase over the last value.

I have tried clng, cstr, abs but none of them seem to work.

Any suggestions?

Edited by - cbeaudry on 29 Apr 2004 08:10:48

I see what you're wanting to do. But if you allow for such precision, will it cause you a problem if the value is greater than 1 and shows 35.921235879?

Because you can change the datatype of the field to float.

I need the precision because because it's precise currency values we're providing, down to 8 decimals.

Well then, can you change it to float?

Is that a database function in Access or can that be done in ASP? I've never worked with a floating point series of data before.

Thought you were working with SQL. I think Numeric will allow precision up to what you need. Just change the datatype to Numeric (after a backup<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>.