I can't get this to work at all - I've attached a copy of the test page where I have 3 recordsets - the new one as you've suggested above (I think) and also two recordsets for the months of March & April which work OK. I've echoed these and the one using the first recordset gives me nothing:
<?php echo $row_rsAccountants['COUNT(clients.AccountantID)']; ?>
The other two return the correct values:
<?php echo $row_rsAccountantsMar15['COUNT(clients.AccountantID)']; ?>
<?php echo $row_rsAccountantsApr15['COUNT(clients.AccountantID)']; ?>