• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

Remove contents of a date field

I have an access database with a table called filings_tbl. In this table I have a field called "Date". The date field is formated as 10/2/2013. Is there a way to clear the contents of this field?
0
Conernesto
Asked:
Conernesto
  • 2
2 Solutions
 
KCTSCommented:
create an update query that replaces the field with NULL
0
 
GrahamSkanRetiredCommented:
Unless the Field has the 'Required' property set, you should be able to delete the field contents.
0
 
KCTSCommented:
Update query
query
BTW - NOT a good idea to used DATE as the name of a field (and its prohibited in some versions of access)
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now