[thelist] currency values in access

Karen J. Bowen karen at miinx.com.au
Wed Jun 12 11:13:07 CDT 2002


(sorry if this is a duplicate, not seeing first post)

having a mental blank - can't recall the currency delimiters for
entering currency values into an Access database with ASP+SQL

e.g.
sSql = "INSERT INTO tblWines(wineprice) VALUES (" & wineval & ");"

What do I need to stick around wineval?  I thought it was a percent
sign, but that's not working.

Thanks in advance,
Karen





More information about the thelist mailing list