Action Query to "Close" records

[Renshers]

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/ open' options. The casework activity is stored in another table (Casework). I believe an action query would work, but I just don't know how!

Sorry if this is really basic and please forgive any omissions in information. Would really appreciate any help! Thanks

 

[jdraw]

How do you identify an activity and when it occurred?
That info is necessary to identify Inactivity for 6 months.

 

[Renshers]

I'm so sorry. I did write a reply but must have messed up in posting it. Not usually that incompetent.

All pieces work/actions done for a client are stored in the 'casework' table by date. This is linked to the 'client details' table where there is a field for whether the case is open or closed. I feel I need something that would look in the casework table to see what the last date was of an action for a client and if it was 6 months or more, it would change open to closed in the client details table. I don't know how to do this!

Many thanks for any help and apologies again for the delay in my reply.