Query to get Count of items

[naomi1017]

Creating Pie Chart from Count Query

My Data gets one of 4 labels: A, R, N, X. I want a pie chart that shows how many of each I have.

I created a query (StatusCounts) using Group By and Count. It lists “OrderStatus” and CountofOrderStatus.

Whenever I use this query to create a chart I get the default Access data not the data that’s actually in that query. Any ideas?

 

[pr2-eugin]

Hello naomi1017, would this SQL Query not suit what you are trying to do?

SELECT OrderStatus, Count(OrderStatus) As CountOfOrderStatus
FROM [tableName] GROUP BY OrderStatus;