Deleting all values of a field

[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.

 

[Tom Lake]

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.

An update query will do it.

Tom Lake

 

[Guest]

Hello, Tom.
And how should I do it?
Thanks.

"Tom Lake" escreveu:

 

[Ed Metcalfe]

The SQL should be something like this:

UPDATE NameOfTable SET NameOfTable.NameOfField= Null;

Ed Metcalfe