I would like to know if it is possible to modify all the data that has been entered in a field in a table. For instance, is it possible to multiply by 10 all the entries in one field so that data can now be entered using a different unit (cm vs mm).
I would like to know if it is possible to modify all the data that has been entered in a field in a table. For instance, is it possible to multiply by 10 all the entries in one field so that data can now be entered using a different unit (cm vs mm).
Of course you can, you would need to use an update query:
Cheers,Code:Update tblYourTable Set [yourCMField]=[yourCMField]*10
As Gicu said, use and Update query. If you are not familiar with code, you can do this in the query window, Go to Create/Query Design, Select the table, Choose Update Query at the top, Select the field and then in the Update To row/box, do the calculation you need like in Gicu example above [filedname]*10, etc.