• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1323
  • Last Modified:

Access Database: Create a formula to calculate a date.

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.
  • 2
1 Solution
LucasMS Dynamics DeveloperCommented:
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 ;-)
NubasianAuthor Commented:
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.  
LucasMS Dynamics DeveloperCommented:
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])

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now