I am uploading an issue log weekly into access. It's a list of numbered tickets from which I can derive which tickets are planned to go into our production system and when (which week of the year) and which tickets got closed and when (in a specifc week of the year).
On my reports I can do a DCOUNT to have a count of "planned" and "closed" tickets per week(number).
I really want to do that count on the original table and put the results in a separate table and work from there. So that separate table should hold the count of how many tickets were planned and closed in a specific weeknumber.
So far I was not lucky doing so using the count function in queries. Anybody has some tips?
On my reports I can do a DCOUNT to have a count of "planned" and "closed" tickets per week(number).
I really want to do that count on the original table and put the results in a separate table and work from there. So that separate table should hold the count of how many tickets were planned and closed in a specific weeknumber.
So far I was not lucky doing so using the count function in queries. Anybody has some tips?
