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

Access Summary Report using COUNT and SUM

P: 1
I'm trying to SUM the CountOf field totals in a report.

In a report based on a select query that uses CountOf{fieldname} I am attempting to get the SUM totals of the X number of count totals.

ie: =sum(CountOfLast name)


I'm getting an error. What formula should i use to achieve this.
Sep 7 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 296
I'm trying to SUM the CountOf field totals in a report.

In a report based on a select query that uses CountOf{fieldname} I am attempting to get the SUM totals of the X number of count totals.

ie: =sum(CountOfLast name)


I'm getting an error. What formula should i use to achieve this.
I'm not 100% sure on this, but I don't think you can use the Sum function on an expression that is in a different grouping. What you can try to do to achieve this is the following (I am assuming your CountOfLastName is in a different grouping than where you're trying to place this sum):
Duplicate your text box CountOf{fieldname}, and under properties change Visible=No and change Running Sum = Over Group. Now, in your report footer (again, I'm assuming that's where you are wanting this sum function), create a textbox with the formula =[NameOfInvisibleControlYouJustCreated]
Sep 7 '07 #2

Post your reply

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