At 10:38 AM 12/17/2002, you wrote: >(snip) ><cfset form.value=form.value*100>
If the goal is to replicate MS Access Money field exactly, then you multiple by 10000 before inserting into db and divide by 10000 when retrieving. MS Access Money field supports 4 decimal places using fixed point data type. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
