I have a macro that formats my table, changes the field names and does a few other formatting operations before I push the data to a MySQL database. Now I want to be able to change the number of decimal places stored in the table to 2 numbers after the decimal. My field name is "Quantity". Is there a property I can use to set this in VBA? I have a web page that sits on the MySQL database, so I want to do all of the operations and other fixes in the Access db so that when I push the data, it is all ready to go.
Thanks in advance!
Run an UPDATE query like this:
UPDATE myTable SET Quantity = Round([Quantity], 2)
Please, keep in mind that proposed Round([Quantity], 2) is Banking, not school (standard) rounding!