• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • 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
 
Brian PiercePhotographerCommented:
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
 
Brian PiercePhotographerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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