<div>
Create a new query in access, select the table you want to use, select the fields you want to display. &nbsp;<br />
<br />
In an empty column type this in: <br />
<br />
Date3: DateAdd(&quot;d&quot;, 60, [date2field])<br />
<br />
That takes care of your question 1 and 2 ;-)
</div>


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 ;-)

<div>
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. &nbsp;
</div>


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.  

<div>
<div class="content wysiwyg-content">
I have a query of two tables (Income table &amp;&nbsp;Project table). This query has 2 date fields &amp;&nbsp;3 dollar amount fields. Date #1 &amp;&nbsp;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. &nbsp;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.
</div>
</div>


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.

Access Database: Create a formula to calculate a date.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.