Why do I lose 0 Zero's when calculating?

easybee · December 17th, 2003, 05:46 PM

I'm trying to calculate total sales by Qty_field * Price_field into Total_field.. all fields are TEXT format. I'm doing this with a SQL statement using FrontPage.. It works find but I lose ending zero's..
Example: 2 * 25.00 = 50 NOT 50.00
2 * 25.32 = 50.64 I dont lose the .64 here.
How can I get it to keep ending zero's?

Thanks

Kenny Bee
EasyBee Software LLC

alyeng2000 · December 18th, 2003, 12:34 AM

try use jscript function parsefloat(text)

Ahmed Ali
Software Developer