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

Reply to this topic