deleting some data

[kris335]

Sorry, I wasn't sure which topic to post this under....



I'm using a copy of last year's database for my county's Christmas program. All my business listings have stayed the same but I need to delete data out of certain fields within each record without deleting those fields (sort of like the "clear contents" option in Excel).

I have 9 fields (in 336 records) that I basically want to wipe all the data out of to start fresh for the new holiday season. (Not all 9 fields are populated in each record, in some records, none of them have data.)

Thanks for any help. Please let me know if you need more info.

Kristy
@ Meck DSS

[orange]

Without knowledge of your application, is it possible to add a Date field eg DateOfXmasProgram
so that you could use the same tables and just update the this new date field. For all existing records, since you only had one set of records, update the date field with last years Date. That way you wouldn't have to delete any records.

Just a suggestion -- without knowing any of the details.

[June7]

You want to remove data from all records? Run an UPDATE query. Under each of the 9 fields on the UpdateTo row use: Null

Alternative is to delete and recreate the fields.

Or if you want to retain previous year info, modify db as orange suggests.