So when I add information into this it should update the source table??
Yes, except for in special cases where you are using non-Updateable Query or Form Types (in which case it will tell you you cannot add/change data).
So for example, I want the date in Date 2 to be 2 weeks prior ot Date 1, so I want to add in =Date-14. But I also want this information to be auto-updating the source table.
You can update tables using the Action Query called Update Query (see "Create an action query" in Access help).
HOWEVER, if the Date2 field (and/or other fields) are solely dependent upon other fields in your table, it is considered poor design to store this information in a table (and your table is not considered to be Normalized -- the goal of all good database desgins).
If certain fields can be calculated from other fields, it is highly recommended that these fields are simply calculated fields stored in queries and not stored in the source table.
Why? Because if Date2 is dependent on Date1, if Date2 is a calculated field in a query, any change to Date1 will automatically update the Date2 calculated value. However, if you are storing Date2's value in a table instead of a query, any change to Date1 will NOT automatically update Date2; you will need to update it manually, or develop another process to update it. Hence, the integrity of your data can be easily compromised.
Remember, all Forms and Reports can use Queries as their sources just as easily as they use Tables, so it is not necessary to store calculated values in tables if they can be calculated in queries.
