Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reset date field to empty

Status
Not open for further replies.

Macdoc

Technical User
Mar 21, 2003
1
US
I have a table that I will archive at the end of each year.&nbsp;&nbsp;After archiving I would like to reset the data in the table.&nbsp;&nbsp;Included in the table is a date field that I would like to set to empty.&nbsp;&nbsp;Is there a way to do this?<br>Thanks for any help.<br><br>Macdoc<br>
 
Can you use an update query? Try using Null as the value you update to.

Good luck.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top