Access Database: Create a formula to calculate a date.

Posted on 2007-08-02
Medium Priority
Last Modified: 2008-06-21
I have a query of two tables (Income table & Project table). This query has 2 date fields & 3 dollar amount fields. Date #1 & Date #2 has information in it. I need to create the Date #3 based on a formula of Date #2 plus 60 days. Once the 3rd date is calculated, that information needs to go into it's own field.  This is a 2 part question: 1) What is the formula to calculate Date #3 and 2) How do I input Date #3 into a separate field. Please give me detailed instructions. I'm a beg-int Access user.
Question by:Nubasian
  • 2
LVL 13

Expert Comment

ID: 19619728
Create a new query in access, select the table you want to use, select the fields you want to display.  

In an empty column type this in:

Date3: DateAdd("d", 60, [date2field])

That takes care of your question 1 and 2 ;-)

Author Comment

ID: 19620631
Thank you lucas911. I asked the 2nd question incorrectly. I actually want the calculated Date3 inserted into a field that exists in the Income table.  
LVL 13

Accepted Solution

Lucas earned 1500 total points
ID: 19621652
Create a new date column in your table.  If you're updating existing records in your income table, then you would change your query to an update query.  The field name is the name of the field you just created and the update to part is:

DateAdd("d", 60, [date2field])


Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

850 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