Access Database: Create a formula to calculate a date.
Posted on 2007-08-02
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.