Hello all,
It's been a very long time since I've tried to work with Access and I'm now having to try and dust off my skills. I have the following issue:
I have a table that has the following fields:
Execution Date
Duration
Expiry Date
The user will input a date in the the Execution Date field, and a numeric number in the Duration field. Based on the Execution Date field, and the numeric value in the Duration field, the Expiry Date field should auto-populate accordingly. But I don't understand how to write the expression. Below is what I have so far but it's not giving me the desired outcome because I don't know where to insert Duration into the expression.
DateSerial(Year([Execution Date])+1,Month([Execution Date])+1,0)
I would appreciate greatly if anyone could please guide me along the right path on how to fix this. Thank you.