Deleting column/altering column contents

[BobLincs]

I am developing a db for a club I belong to and at the end of a season some content needs to be deleted.

Can anyone give the syntax to attach to button that will step through the records and delete the content of a field or fields please.

 

[Galaxiom]

Rather than deleting it is better to add a "deleted" flag (Y/N checkbox field). The form is designed to hide any "deleted" entries unless a checkbox is ticked to show them.

This way any delete errors are easily reinstated.

Changing any value in a record is done with an Update query using a where clause that selects the target records.

 

[BobLincs]

Thank you. I'll give that a try.