Solved

Remove contents of a date field

Posted on 2013-12-02
3
338 Views
Last Modified: 2013-12-02
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
Comment
Question by:Conernesto
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 70

Assisted Solution

by:KCTS
KCTS earned 500 total points
ID: 39691198
create an update query that replaces the field with NULL
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 39691207
Unless the Field has the 'Required' property set, you should be able to delete the field contents.
0
 
LVL 70

Accepted Solution

by:
KCTS earned 500 total points
ID: 39691213
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question