Delete all data from field? (1 Viewer)

[cambonner]

A database at our Food Pantry needs to be updated yearly on Jan. 1 by eliminating all data in two fields: "ID Check Date" (date field) and "Signature Obtained" (check box). There are hundreds of records. Is there a way to remove the data from the two fields (columns) while retaining the fields (and their formats) but with no data? We use Access 2010.
Thanks!

 

[pbaldy]

Sure, an update query:

UPDATE Tablename
SET [ID Check Date] = Null, [Signature Obtained] = 0

try it on a copy of course.

 

[cambonner]

Hi Paul,
Thanks for your quick and helpful reply. It worked like a charm.
Happy New Year (you've already made mine start off happy),
Cameron

 

[pbaldy]

Happy to help Cameron!