order count

[Guest]

I want to make a query that counts the number of orders I have in my database
from each company. I know how to add all of the monetary values of those
orders together in a query, but I do not know how to find out how many orders
there are total. thanks

 

[Guest]

Use the count in a group by query

SELECT MyTable.company, Count(MyTable.orders) AS CountOfOrders
FROM MyTable
GROUP BY MyTable.company