How to update nujmber each day

[kentwoodjean]

I am not quite sure how to do this, although it seems I should be able to. Have a table called "Open Cases" which lists all the contracts that are still pending and have not been closed. Each contract may have been received a different date and is subsequently closed on a different date. Therefore, the number of contracts on this list will change by day.

I want to be able to get the number each day that are currently open and maintain a Table or query that will keep that number by date as it changes. I am thinking maybe I need an update query but I am not sure what to do to make it work. I do not want to include Saturdays or Sundays for my dates. I will show you the SQL of my query that gives me the number as of today, with hopes someone can assist me.

SELECT Date() AS [date], Count(tblOpenCases.[Contract #]) AS [CountOfContract #]
FROM tblOpenCases
GROUP BY Date();

 

[kentwoodjean]

Ok, I am answering to myself. I have been messing around with this and think that I actually need an append query. Is that correct? I am really not familiar with append queries but did set one up and it worked fine. Now my question is this, do I need to run this query every day to transer that days results to a table? Will this happen automatically when the database is opened? Or do I need to write some kind of code? In looking at the help index, posts on this site, and my Access for dummies book, I cannot get a clear answer.