OK, with some playing, this is what I ended up with...
5 x queries, one to total the number of jobs in a month, one to total the number of missed jobs per month, one each to total those figures and one to work out the percentage missed. I didn't realise but some of the collections have...