I want to show how many staff worked for us throughout each month of the year. I think I can only use their start dates to work this out but I don't see how I can calculate to say there were 100 staff in April and 120 in May etc. when it will be the same people month on month give or take new starts, leavers ect. At the moment I have only managed a query that shows how many people have a start month of April, May etc. but I need total staff employed.
Can anyone help?
Can anyone help?