I have a table with the following fields. I'm trying to count the number of times the same string appears in ItemID, the same string in ModelID for each LocationID.
SELECT Count([Table1].ItemID) AS ItemCount, Count([Table1].ModelID) AS ModelCount, [Table1].LocationID
(SELECT DISTINCT [Table1].LocationID FROM [Table1] );
The error states Query does not include LocationID as part of Aggregate function.