ASP.NET, SQL Server, WPF, C#, VB.NET

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 
 
-- 
 
hth 
 
Al Camp 
 
Candia Computer Consulting - Candia NH 
 
http://home.comcast.net/~cccsolutions 
 
"kilalinei" <kilalinei@discussions.microsoft.com> wrote in message 
 
news:85DA9CD9-4CE4-4B85-A88B-6BC9E2794D47@microsoft.com...