I have a very rudimentary knowledge of MS Access 2003.
We use Access to record casework for clients. We would like to show a record as closed if there has been no activity for 6 months.
Whether a case is open or closed is simply shown as a field in a table (Client details) with 'closed/...