Deleting specific field content 1

[misslil]

We want to create a database that once a year will have the contents of specific fields deleted. This is for our tax department. They want to retain the informational fields but on a yearly basis clear the numeric fields. Any thoughts on how we can accomplish this in an Approach Database.

 

[Thomasdelta]

Not sure if I completely underestimated the problem here, but have you tried creating a macro that finds all records between the specified dates and then runs another macro which starts at the first record, and then sets all the required fields to '' (blank).
(you will have to use the Set command once for each field required).

Sorry if this post is too late!!




I read a book once called '101 Things to do in Binary'.
It was the best 5 things I ever read.

 

[misslil]

Thanks Thomasdelta

Using a macro is what we came up with.