Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sum Max help (Add 1 Month)

Posted on 2016-11-12
3
Medium Priority
?
47 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 31

Accepted Solution

by:
hnasr earned 2000 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 31

Expert Comment

by:hnasr
ID: 41885393
Welcome!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

885 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