[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