Count Data on a Report & summarize it at the end

[beacon]

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?

Program
            Skill Level 1
                            Doe   John    555-1234    [e-mail]
                            Doe   Jane    555-2345    [e-mail]
            Skill Level 2
                            Doe   Matt    555-3456    [e-mail]
                            Doe   Mary    555-4567    [e-mail]
 
                                          Total for Skill Level 1         2
                                          Total for Skill Level 2         2
                                          Total for All Employees         4
 

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

[beacon]

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

[Jim Doherty]

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 :)

[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 :)

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