Solved

Remove contents of a date field

Posted on 2013-12-02
3
340 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

623 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