Currency/Number fields displayed with no decimals

float and decimal data types are very different

by definition the float data type "floats" the decimal place ie

600.00 is 600

600.10 is 600.1

600.01 is 600.01

etc.
the decimal data type allows one to set the precision and scale of the data ie

decimal(5,0) is 600

decimal(5,1) is 600.0

decimal(5,2) is 600.00
you still won't get the $ sign as it is a charecter data type and cannot be stored in a numeric field. you will need to fromat the $ using concatenation i belive.
HTH

George

actually try the FormatCurrency() method...

FormatCurrency() is the way to go:

http://www.w3schools.com/Vbscript/func_formatcurrency.asp

I understand the SQL formatting, as I tried decimal etc. However, on the EDIT form or ADD form, no matter what I do with ASPRunner on properties, I cannot get the numbers to display with decimals. I've checked it off to display as number with 2 decimals, the data is stored in SQL as 600.00, and still it only shows 600 on the form. Surely the formatting option should take care of this without any additional coding.

Another question, if I'm adding ASP code (under the After or Before Record updated), would it be something like this:
<script type="text/vbscript">

document.write(FormatNumber("HourlyRate" ))

</script>

You need to apply FormatNumber or FormatCurrency in 'View as' Custom.

Here is the sample code:

or

Tried that too, and it still just shows 600. Ok, I'm really feeling dumb, as I know it's something that should be simple. I'll upload the project. Project 3 is the name.

Ok, I uploaded the project but no data is showing up. If you go to STAFF, then SCHEDULES, EDIT....there are no records. My database has some test records in it and although I checked "upload tables", it doesn't seem to be uploading.

Update: correct variable name is strValue

If this doesn't help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.