This
query example lists each city and the number of orders sent to
that city from the ExampleData.xls database.
Queries that use COUNT can not be displayed by Microsoft
Query. You must enter the text of this query in SQL View in
Microsoft Query.
If you try to switch to Query View an error will occur.
The TEST button does work and can be used to see the result
set in Microsoft Query.
SELECT ShipToCity, Count(*)
as CountOfOrders FROM Orders GROUP BY ShipToCity
Tip: Sometimes certain characters
in the font within a data source can cause odd behavior. This
can be due to the language of the source data; or perhaps
special characters are in the source table.