I've written this SQL , running it in Access 2003, which produces the information I need, including a footer showing the Total.
However, I would like to Sort Col1 alphabetically (From A-Z), but so far, has been unsuccessful. Below is the main pseudcode for this:
SELECT “Total“ AS Col1, “ “ AS Col2, “ “ AS Col3, Count([TableA.Column1]) AS [Count_TableA_Column1]
FROM…TableA INNER JOIN TableB INNER JOIN TableC
SELECT TableB.Col1, TableB.Col2, TableB.Col3, Count([TCPIP Table].[Term #]) AS [CountOfTerm #]
GROUP BY TableB.Col1, TableB.Col2, TableB.Col3
ORDER BY Col1, [Count_TableA_Column1]
Col1 Col2 Col3 CountOfTerm#
A - - 5
D - - 4
Z - - 2
When I remove the "Col1" from the "Order by" in the second SELECT, I get the "Total" row pushed to the bottom, but then the Col1 is all unordered like this, but the Total appears at the bottom, as I want it.
Is there a way to order by Column 1 while still getting the Total Row at the bottom? Thanks for any help