Let me start by saying I am very new to Access and am trying to learn as I go. I am not sure if what I need is a macro or formula.
I have a table with records. I created a form to reflect and to enter more records because these records were exported from another database program called Alpha version 4. I now have the form designed structurally the way I want it. In this form I have some date and number fields that represent the amount of days a person will be on a trip. The clerk will enter this information, however, for the date fields, if possible, I would like these to auto-fill the date of when they will return.
Example:
In field A I will enter the date of departure (1/7/2014). In field B I will enter (90) which is the amount of days I will be gone. Then in field C I would like it to auto-fill the date of when I will return which is (3/7/2014) 90 days later. So basically I want it to calculate from the start date to however many days I enter to give me the end date of when I will return.
Any help in how to get this done would be great. Thank you for your time in advance.