Help with Count function in Access

[AZKing]

Hi all,

I am trying to create a query that will count the number of items in a certain field. For example, the number of cars listed as "Ford" in the USA. I can do it for just one item, but there are multiple brands that I would like to include as well. How would I go about counting the number of Chrysler's and Chevy's also in this query? Any help is greatly appreciated. Thank you very much.

P.S. Below is the code that I have so far for counting just one item in a field.


SELECT DISTINCTROW [Item List].[Country], Count([Item List].[Brand]) AS [Count Of Ford's]
FROM [Item List]
WHERE (([Item List].[Country])="USA") AND (([Item List].[Responsible Area])="Ford")
GROUP BY [Item List].[Country];

[MMcCarthy]

SELECT [Item List].[Country], [Item List].[Brand], Count([Item List].[Brand]) AS CountBrand
FROM [Item List]
GROUP BY [Item List].[Country], [Item List].[Brand];

Hi all,

I am trying to create a query that will count the number of items in a certain field. For example, the number of cars listed as "Ford" in the USA. I can do it for just one item, but there are multiple brands that I would like to include as well. How would I go about counting the number of Chrysler's and Chevy's also in this query? Any help is greatly appreciated. Thank you very much.

P.S. Below is the code that I have so far for counting just one item in a field.


SELECT DISTINCTROW [Item List].[Country], Count([Item List].[Brand]) AS [Count Of Ford's]
FROM [Item List]
WHERE (([Item List].[Country])="USA") AND (([Item List].[Responsible Area])="Ford")
GROUP BY [Item List].[Country];