Solved

Remove contents of a date field

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Calculate Time acces 2010 12 29
Need help constructing a conditional update query 16 46
Filter a form 8 15
Need excel formula correction. 5 7
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
This article will show you how to use shortcut menus in the Access run-time environment.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

777 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