Sum the Count

[Adele]

Hi all,



I have a table called ‘Invoice Details’ and would like to know the sum of the count of ‘Order Number’.

Is it possible to sum the count of the column ‘Order Number’ in the same query?

Many thanks,

Adele

[fmdj]

What do you mean by sum of the count? Is it not just the count?

[khalid]

What query you use to get the sum?
you might need to creat another query based on your query to get the sum of your counted record

[Adele]

i will be summing the count of the invoices for each month

[Adele]

Khalid, yeah i this is what i have already, i create the first query then use the count column in the next to group by month, i was wondering if i could get it down to just one action

[fmdj]

Count of the invoices for each month :

SELECT month, COUNT([Order Number]) FROM [Invoice Details] GROUP BY month

Count of all invoices:

SELECT COUNT([Order Number]) FROM [Invoice Details]