Solved

Remove contents of a date field

Posted on 2013-12-02
3
334 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
  • 2
3 Comments
 
LVL 70

Assisted Solution

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

Expert Comment

by:GrahamSkan
Comment Utility
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
Comment Utility
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

My experience with Windows 10 over a one year period and suggestions for smooth operation
Outlook Free & Paid Tools
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

728 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now