Statistics based on predefined period in another table

Hi, I need to create incidents statistics occurred in a predefined period for :- i) Incident count by period ii) Backlog by period iii) Backlog completed by period   So, there is a Period table...