group by date to create daily invoice totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a query that includes dates and daily invoice amounts. Each
date has more than one invoice entry. I need to create in my query a column
that will combine invoice totals for each day.
 
kilalinei,
Do a Totals query. (View/Totals in query design)
Given this data
InvDate InvNo Amt
1/1/06 123 10
1/1/06 372 20
1/1/06 531 15
1/2/06 882 5
1/2 06 931 20

Drop the InvNo from the Totals query.
GroupBy on the InvDate column, and Sum the Amt column.
That yields...
InvDate Amt
1/1/06 45
1/2/06 25
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Creating a Total from a Sub Report 1
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
query set up question 6
One query record results as 2 separate lines?? 2
Outlook Creating an Outlook form 2
Find Last Date Invoiced for Each Customer 3
DSum Total 1

Back
Top