bundling a large database using two fields; by business name and m

[Rose]

I need to to produce a report and send through excel; running the simple
query produces about 117,000 records. I want to sum all records that belong
to a business by month.
How can I ensure that this is done.

 

[Tom van Stiphout]

You want to export to Excel for the purpose of summing by customer and
month?
Access can easily do this using a Totals query. For example:
select CustomerID, Month(InvoiceDate), sum(SalePrice)
from tblInvoices
group by CustomerID, Month(InvoiceDate)

(yes I know this does not handle multiple years; I leave that up to
you)

-Tom.
Microsoft Access MVP

 

[KARL DEWEY]

Try this to include years --
select CustomerID, Year(InvoiceDate), Month(InvoiceDate), sum(SalePrice)
from tblInvoices
group by CustomerID, Year(InvoiceDate), Month(InvoiceDate);