[thelist] currency delimiter

Karen J. Bowen karen at miinx.com.au
Fri Jun 14 07:48:01 CDT 2002


having a mental blank...

writing an INSERT statement for an Access DB and cannot remember (nor
find) the delimiters for a currency data type.

I've got:

sSql = "INSERT INTO tblWines(singlePrice, allPrice) VALUES (" &
singlecost & ", " & allcost & ");"

where singlecost & allcost are currency fields in the db.

I thought % was the currency delimiter but that ain't working.

Thanks,
Karen




More information about the thelist mailing list