By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,591 Members | 629 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,591 IT Pros & Developers. It's quick & easy.

running sum issue

P: 14
MS ACCESS 2003
I'm using a running sum on a report to total points scores.
But what i want to do is run to say 325 points and then for the sum to start agiain, also carrying any extra points when its reached 325.

Thanks
Adam
Mar 17 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
MS ACCESS 2003
I'm using a running sum on a report to total points scores.
But what i want to do is run to say 325 points and then for the sum to start agiain, also carrying any extra points when its reached 325.

Thanks
Adam
The only thing I can thing of is a complicated IIF statement.

Something like ...
Expand|Select|Wrap|Line Numbers
  1. =IIf(Sum([FieldName])<=325,Sum([FieldName]),IIf(Sum([FieldName])<= 650,Sum([FieldName])-325,Sum([FieldName]))
Mary
Mar 22 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.