Solved

Sum Max help (Add 1 Month)

Posted on 2016-11-12
3
28 Views
Last Modified: 2016-11-13
Experts, I have a query that sums based on a month (sums the Max).  I also have a field in this query that adds a month to [Date_Append].  I want to sum based on this "add one month" date just as I do for the [Date_Append].

I have uploaded a sample file.
Grateful for your help.
I hope it is clear, any questions are welcome.  

example:
Date_Append      MaxODCum      MaxWCCum      SumMax             add1Mo                 SumMaxAddMo:
2016 Sep             $80.00             $339.70             $419.70             2016 Oct       (I want to show the sum for Oct)
2016 Oct             $95.00             $350.50             $445.50             2016 Nov      (I want to show the sum for Nov)
2016 Nov             $102.20             $470.00             $572.20             2016 Dec      (I want to show the sum for Dec)
SumAddMonth.accdb
0
Comment
Question by:pdvsa
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
hnasr earned 500 total points
ID: 41885158
Check Query1
Joined your query with itself to display next month's values.
SumAddMonth-2.accdb
0
 

Author Closing Comment

by:pdvsa
ID: 41885340
perfect.  thank you
0
 
LVL 30

Expert Comment

by:hnasr
ID: 41885393
Welcome!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 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