Hi
Is it possible to have a query/Form/report that shows me this desired result
W1
Received 10
Processed 4
Opened 6
W2
Received 10
Processed 12
Opened 4
etc.
Where access can count how many opened issues from week1 were solved and processed on week2 and then in week2 he will show how many were opened in week1 plus the one received minus the proccessed one and show how many are still opened?
Can that be done in Access at all or should I rely on Excel.