[thelist] currency values in access

[Karen J. Bowen]

Chris Blessing wrote:
> Karen-
>
> IIRC single quotes should do it.
>
> sSql = "INSERT INTO tblWines(wineprice) VALUES ('" & wineval & "');"
>

Think I was over-complicating things!  Thanks Chris, that's it.

cheers,
Karen