Sum of Weekending

Is there a way to give total for the week ending for each week in the Year
Grand total for each week would be put into field [SumOftotalWorkWeek]

I included a Test Database for this scenario.
Table: Copy Of Date_Sales
Query: Query1
WeekEndingTotals.mdb
ca1358Asked:
Who is Participating?
 
GozrehConnect With a Mentor Commented:
Change your Query1 to this
SELECT Max([Copy Of Date_Sales].SalesDate) AS LastDateOfWeek, (DatePart("ww",[SalesDate])) AS WorkWeek, Sum([Copy Of Date_Sales].LoanAmt) AS SumOfLoanAmt
FROM [Copy Of Date_Sales]
GROUP BY (DatePart("ww",[SalesDate]))
ORDER BY Max([Copy Of Date_Sales].SalesDate);

Open in new window

0
 
ca1358Author Commented:
Thank you very much!!
0
All Courses

From novice to tech pro — start learning today.