I am pretty new when it comes to Access and I am in the process of creating several forms to populate a database. In the table, I have a field to enter the date and I have another field that needs to have a 'destruction date' listed. Basically, I want the 'destruction' field to take the date entered in the previous field, add 90 days to it and display the calculated date (example below).
Date: 10FEB2017
(plus 90 days)
Destruction date would equal: 10MAY2017
I attempted to enter the calculation =[Date Logged]+90 but I am greeted with a pop up window stating "You cannot set 'Destruction Date' to the Calculated data type."
If anyone can help solve my problem, it would be much appreciated.
Thanks for reading.


Date Calculation auto fill - date plus 'x' days
Reply With Quote

