I have a query that generates a list of website topics from our CMS database. In addition to what it pulls from the database, the page also shows page counts for each topic, and the counting is done in the code, not the SQL. It's worked well for a number of years.

As time has passed, we've added a lot of content, so now I want to be able to sort by page count. So that means adding COUNT to the query.

But I still get the same error. I wonder if it's an Access thing (yes, despite SQL Server 2008 being available, we STILL have to use Access because they haven't decided who will have access to create/modify databases).