Deleting all values of a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.
Is it possible to create a macro which deletes the values of a certain field
from all records of a certain table (all records)?
The idea is, at a certain time, to click in a button and all the values
entered in a certain field in a table will be deleted and became empty.
Thanks in advance.
 
acores said:
Hello.
Is it possible to create a macro which deletes the values of a certain
field
from all records of a certain table (all records)?
The idea is, at a certain time, to click in a button and all the values
entered in a certain field in a table will be deleted and became empty.
Thanks in advance.
Click to expand...

An update query will do it.

Tom Lake
 
The SQL should be something like this:

UPDATE NameOfTable SET NameOfTable.NameOfField= Null;

Ed Metcalfe
 
Back
Top