• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 49
  • Last Modified:

Sum Max help (Add 1 Month)

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
pdvsa
Asked:
pdvsa
  • 2
1 Solution
 
hnasrCommented:
Check Query1
Joined your query with itself to display next month's values.
SumAddMonth-2.accdb
0
 
pdvsaProject financeAuthor Commented:
perfect.  thank you
0
 
hnasrCommented:
Welcome!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now