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.