Forums
This topic is locked
Inserting data into currency field
Posted 01 Oct 2009 15:56:48
1
has voted
01 Oct 2009 15:56:48 Peter Borcherds posted:
Guys,I'm struggling with this...I need to insert an amount from a form into a field in an Access database that is set as currency datatype.
When I enter 125.25 in the form it gets inserted into the database as £12,555.00 - how do I get it to be inserted as £125.55 using Dreamweaver (ASP VBScript)?
Thanks!
Peter
Replies
Replied 01 Oct 2009 23:42:28
01 Oct 2009 23:42:28 Patrick Julicher replied:
Hi Peter,
Try inserting 125,55 instead of 125.55 (comma).
Kind regards, Patrick
Try inserting 125,55 instead of 125.55 (comma).
Kind regards, Patrick