473,326 Members | 2,337 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Count Data on a Report & summarize it at the end

beacon
579 512MB
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
3 2901
beacon
579 512MB
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
897 Expert 512MB
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
579 512MB
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

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

Similar topics

7
by: Will | last post by:
On the subject of Data Warehouses, Data Cubes & OLAP…. I would like to speak frankly about Data Warehouses, Data Cubes and OLAP (on-line analytical processing). Has it dawned on anyone else...
2
by: SJM | last post by:
I have a report that displays records of real estate properties. It is possible for each property to appear a number of times for various reasons. Each record however is unique. What I would like...
1
by: Jessica | last post by:
I have a database where a person is able to enter the different tasks they do each day by specific department and matter. On a form they enter the date, their name, and their title; in a subform...
1
by: James | last post by:
Access 2003, trying to count the number of records that meet a criteria. According to Help: "In the Database window, click Queries under Objects, and then click New on the database window...
3
by: Miguel | last post by:
I have a parameter query to filter by date from which I run a report. I need to be able to count the number of times a particular product or error type appears after the report is run from the...
1
by: heckstein | last post by:
I am working in Access 2002 and trying to create a report from our company's learming management system. I am not a DBA and most of my SQL knowledge has been self taught through trial and error. I...
5
by: Dean | last post by:
Hi, I have a table with non-unique identifiers. I need to take all the values with the same ID's and combine them into one field with a semicolon as a seperator. These values may exceed 255...
1
by: nospam | last post by:
I have a report to count some statistics of case data. I can't figure out how to make Access group and sum/count information to give me a nice statistics report. Basically the database has case...
1
misscrf
by: misscrf | last post by:
have a report that I am trying to build and I can't figure out how to make Access group and sum/count information to give me a nice statistics report. Basically the database has case information for...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.