Solved

Sum of Weekending

Posted on 2014-02-13
2
228 Views
Last Modified: 2014-02-13
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
0
Comment
Question by:ca1358
2 Comments
 
LVL 10

Accepted Solution

by:
Gozreh earned 500 total points
ID: 39856849
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
 

Author Closing Comment

by:ca1358
ID: 39856892
Thank you very much!!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now