OK so this is creating a new recordset using COUNT function and GROUP BY statement.
But the problem is the html table showing the account list is using another recordset and a repeat region, so I think I’m right in thinking that binding data from the new recordset wont work.
How can I marry this together.
I’ve attached the page. SO the recordset that populates the list is rsActiveApps. The recordset that I have replicated your suggestion is rsAllPaid.
The table where I need to highlight the rows is under <h1 class="page-head">Admin - Live Applications</h1> line 383