I have a field defined as currency. How do I write the following query in VBA so it will be accepted and form a new row?
strSQL = "Insert INTO test (money) Values ($0.00);"
DoCmd.RunSQL strSQL
field: money
field size: long integer
format: currency
decimal places: auto
I know it's a stupid Insert but it just for learning.
strSQL = "Insert INTO test (money) Values ($0.00);"
DoCmd.RunSQL strSQL
field: money
field size: long integer
format: currency
decimal places: auto
I know it's a stupid Insert but it just for learning.