Delete select fields with a query?

[Guest]

Is it possible to deleted data from certain fields on a particular record,
automatically like with a query of some sort? I would use the criteria of
course to determine which records to select....

Thanks

Curtis

 

[Allen Browne]

Use an Update query to set the fields to Null.

1. Create a query using this table.

2. Enter the criteria so you are seeing the records that need to be changed.

3. Change it to an Update query (Update on Query menu.)
Access adds an Update row to the grid.

4. In the Update row under the fields you want to clear, enter:
Null

5. Run the query. The fields will be updated to Null, i.e. any value in the
field will be removed.

 

[Guest]

Thank you!