[thelist] currency values in access

Karen-

IIRC single quotes should do it.

sSql = "INSERT INTO tblWines(wineprice) VALUES ('" & wineval & "');"

Chris Blessing
webguy@mail.rit.edu
http://www.330i.net

> (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