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

Count Data on a Report & summarize it at the end

beacon
100+
P: 579
Hey everybody,

I'm using 2003 and wondering if there's a way to count the data for multiple sections in a report and summarize it at the end of the section. For instance, I have a report with a header for different programs. I have another header for skill level. Then, after both of those, I have data for employees. After the data for each of the employees and the skill levels, I want to summarize it in the programs footer. Is this possible?
Expand|Select|Wrap|Line Numbers
  1. Program
  2.             Skill Level 1
  3.                             Doe   John    555-1234    john.doe@email.com
  4.                             Doe   Jane    555-2345    jane.doe@email.com
  5.             Skill Level 2
  6.                             Doe   Matt    555-3456    matt.doe@email.com
  7.                             Doe   Mary    555-4567    mary.doe@email.com
  8.  
  9.                                           Total for Skill Level 1         2
  10.                                           Total for Skill Level 2         2
  11.                                           Total for All Employees         4
  12.  
I know how to get the total for all, but I haven't been able to get it for the individual skill levels. I have a skill level id field with skill level that is delineated with 1s and 2s if that helps.

Thanks,
beacon
Oct 25 '07 #1
Share this Question
Share on Google+
3 Replies


beacon
100+
P: 579
I don't know if it's against the rules to reply to your own post because I'm too lazy to go read the rules, but I wanted to check one more time to see if any might have a solution to my problem. I'm also open to suggestions about how I might reorganize my data to make summarizing it more efficient.

Thanks,
beacon
Oct 26 '07 #2

Jim Doherty
Expert 100+
P: 897
I don't know if it's against the rules to reply to your own post because I'm too lazy to go read the rules, but I wanted to check one more time to see if any might have a solution to my problem. I'm also open to suggestions about how I might reorganize my data to make summarizing it more efficient.

Thanks,
beacon
OK have you setup anything in 'Group Headers and footers' before in Access? because if you are summing or counting within each group level the customary way is to place and unbound textbox control in the footer of each grouped section and count on the number of IDs within each group.
For instance in the controlsource of the textbox simply type =Count([ID]) where id represents the name of the field that you want to count on in that group

You need to turn on the footer section for each group it doesnt show by default in Report design....View...Sorting and Grouping ....in the dialog box turn on group footers and put the textboxes however many you want to use in there.

Jim :)
Oct 26 '07 #3

beacon
100+
P: 579
OK have you setup anything in 'Group Headers and footers' before in Access? because if you are summing or counting within each group level the customary way is to place and unbound textbox control in the footer of each grouped section and count on the number of IDs within each group.
For instance in the controlsource of the textbox simply type =Count([ID]) where id represents the name of the field that you want to count on in that group

You need to turn on the footer section for each group it doesnt show by default in Report design....View...Sorting and Grouping ....in the dialog box turn on group footers and put the textboxes however many you want to use in there.

Jim :)
Hi Jim,

I've got a count function setup and all of my footers turned on, but the problem is that I want to count everything for the skill level but have it summarized in the program footer.

I haven't been able to find a way to go back and forth between to sections of a report or if it's even possible.

I posted another question asking if you can use queries in reports and am waiting for a response. If you can, I already have a query statement written waiting to go.

Thanks for your reply,
beacon
Oct 26 '07 #4

Post your reply

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