Report - Summing issue

Experts, I have this report that is in development. (rptFacilAvail2)
What I need is a sum of Available Per Month.
You can see from the pic that I am not getting the correct balance based on the previous month.  
I think you can see from the pic what the issue is instead of trying to explain by words.  

Need some advice on how to do this trick.  (You can also see that the month order is not correct)

thank you

I attached the db.

 reportsummpicEE-report.zip
pdvsaProject financeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
ok.. test this
EE-report.accdb
0
 
Rey Obrero (Capricorn1)Commented:
test this


EE-report.accdb
0
 
pdvsaProject financeAuthor Commented:
Ok.  Thanks.  Not at computer and might not be for some time.  
0
 
pdvsaProject financeAuthor Commented:
Cap, is it possible to group those months together?  Please see attachment.  Thank you.
Presentation1.jpg
0
 
pdvsaProject financeAuthor Commented:
Thank you.  I see how you fixed it.  Really appreciate it.  I will ask another question about this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.