I am creating a small database in access for maintaining some data. My question is as under, please help.
I made a table in access and put a column contract_end_date. I just want if the current date(means today date) is greater than the contract_end_date status automatically comes "closed" in the next cell and if the contract_end_date is less than current date(means today date) status automatically comes "Active" in the next cell. If I put any date like 01-jan-2014 in the contract_end_date as it is less than current date(26-jun-2015) it shows status "Active". If I keep contact_end_date blank, status shows "Closed".
It is necessary to put date in contact_end_date column for records.
Contract_End_Date Contract_Period Status
Closed 31-Mar-2017 2 Active
Closed 30-Jun-2016 3 Active 30-Nov-2015 3 Active 31-May-2015 1 Active 31-Oct-2017 3 Active 31-Jan-2016 1 Active 30-Sep-2015 2 Active
Closed 31-Mar-2016 1 Active 12-Jul-2016 2 Active 30-Nov-2017 3 Active
Closed 30-Nov-2018 4 Active
Closed