Emptying fields

[BobLincs]

I have produced a dbase for my bowls club. At the end of the season some contents of tables will need to be emptied ready for next season.

Can anyone provide me with the syntax to attach to a button on a form, that will loop through the records and delete the contents from various fields please.

Boblincs

 

[John Big Booty]

You could use a delete query to do this. However you should be very careful when deleting historic data, it may be better to archive it in case it is require further down the track.

 

[BobLincs]

Thanks, I'll try that.

 

[BobLincs]

Have looked at delete query but it specifically states that it can't be be used to delete contents of individual columns which is what I am looking for.

My idea is some sort of loop that will step through each record and empty specified fields.

I know I could do it the long way with a Next Record button changing specific fields to "" or 0. I was just hoping there might be a quicker way.

 

[John Big Booty]

Have a look at an update query then. You can use that to set specific fields to whatever value you choose.

 

[BobLincs]

thanks again.