Does anybody know how I would make a macro in access 2007 that deletes all data in a certain column in a certain table?
I'm using 2003, but I assume the same applies in 2007.
- Create a new macro.
- From the Action dropdown, select RunSQL.
- In the SQL Statement box enter:
UPDATE [TableName] SET [FieldName]=NULL;
- Save the macro.
Run the macro to delete the data from FieldName in TableName.