I have an Access database set up. I want to be able to add 120 days to my hire date field and then enter this date automatically into my rehire date field in my table. Then from my rehire date field I need to constantly update this field by 120 days to another field which would cycle through every 120 days. How could I do this?
