If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Repost-Need Help with Running Sum Problem
Can anyone please help me with this problem. I have a
running sum field in a report for job categories, they total on each Call ID and then have a Grand Total where the total of all of them come together at the bottom to be included with the other rates based on the total amount for the Date. My challenge is that they all total fine for each date on Group All except when one of the items in the job category field has a 0.00 value, then the running sum stops at the item above it say 145.00, doesn't do anything with the zero value one and then puts a 0.00 value in the Grand Total field instead of the 145.00. As long as the fields are all full it seems to work. Can anyone help me with what would be correct to make this work so that the amount that is supposed to be on the bottom shows up. Thanks, all help gratefully appreciated. IEJ |
#2
|
|||
|
|||
Repost-Need Help with Running Sum Problem
See previous post.
-- Wayne Morgan Microsoft Access MVP |
Thread Tools | |
Display Modes | |
|
|