If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I create a Top 5 percent report?
I'm new to Access, so please treat me like an infant.
What I'm trying to do is create a report that will show the Top 5 Best/Worse product testers on a daily/weekly basis, based on the number of good and bad tests they produce. I know that a report starts with a Query, but I have no idea where to go from there. All the core information is established, I just need this specific report. Any and all assistance is GREATLY appreciated. Thanks! RasJr. |
#2
|
|||
|
|||
How do I create a Top 5 percent report?
Open the query in design view. Open the Properties window for the query.
Use the TOP property and set it to 5. If you also want the bottom 5, open the query in design view. Sort (descending). Use the TOP property and set it to 5. Regards Jeff Boyce Microsoft Office/Access MVP "RasJr." wrote in message news I'm new to Access, so please treat me like an infant. What I'm trying to do is create a report that will show the Top 5 Best/Worse product testers on a daily/weekly basis, based on the number of good and bad tests they produce. I know that a report starts with a Query, but I have no idea where to go from there. All the core information is established, I just need this specific report. Any and all assistance is GREATLY appreciated. Thanks! RasJr. |
#3
|
|||
|
|||
How do I create a Top 5 percent report?
Thanks, Jeff!
I was able to set the TOP property to 5 and it worked, but I have a couple of follow up questions.? In the Query, I'm using two Fields ("Tester" & "Test was:"). The Tester field obviously contains all the the testers contributing to the database; but the Test was: field contains three options (Bad, Good, & Good w/ Notes). My question...how can I single out the Top 5 Good tests, and the Top 5 Bad tests based on the number submitted? My second question...I was unable to select the "descending" option while in Design View. I can see it on the Home tab, however it's not open for selection. Am I completely off base on that? Thank you again for your assistance! This is a great lesson for me. V/r RasJr. "Jeff Boyce" wrote: Open the query in design view. Open the Properties window for the query. Use the TOP property and set it to 5. If you also want the bottom 5, open the query in design view. Sort (descending). Use the TOP property and set it to 5. Regards Jeff Boyce Microsoft Office/Access MVP "RasJr." wrote in message news I'm new to Access, so please treat me like an infant. What I'm trying to do is create a report that will show the Top 5 Best/Worse product testers on a daily/weekly basis, based on the number of good and bad tests they produce. I know that a report starts with a Query, but I have no idea where to go from there. All the core information is established, I just need this specific report. Any and all assistance is GREATLY appreciated. Thanks! RasJr. |
#4
|
|||
|
|||
How do I create a Top 5 percent report?
see comments in-line below...
"RasJr." wrote in message ... Thanks, Jeff! I was able to set the TOP property to 5 and it worked, but I have a couple of follow up questions.? In the Query, I'm using two Fields ("Tester" & "Test was:"). The Tester field obviously contains all the the testers contributing to the database; but the Test was: field contains three options (Bad, Good, & Good w/ Notes). My question...how can I single out the Top 5 Good tests, and the Top 5 Bad tests based on the number submitted? If you only have two fields, how are you deciding what represents the "Top 5"? My second question...I was unable to select the "descending" option while in Design View. I can see it on the Home tab, however it's not open for selection. Am I completely off base on that? When I use design view of a query, one of the rows in the bottom pane is Sort: Thank you again for your assistance! This is a great lesson for me. V/r RasJr. Regards Jeff Boyce Microsoft Office/Access MVP |
#5
|
|||
|
|||
How do I create a Top 5 percent report?
If you only have two fields, how are you deciding what represents the "Top
5"? I'm not sure...What I'm wanting is a report that will show the Top 5 Good testers with the least amount of "Bad" tests to their name, and (hopefully in the same report) the Top 5 Bad testers with the most "Bad" tests to their name. I created a pie chart using the "Tester/Test was:" Query, and assumed that if tweaked a bit could display a Top 5 Good/Bad report. One thing that I would think to add would be the "ID" feild, which holds each tester's individual ID #...but again, I'm a novice with Access. V/r RasJr. "Jeff Boyce" wrote: see comments in-line below... "RasJr." wrote in message ... Thanks, Jeff! I was able to set the TOP property to 5 and it worked, but I have a couple of follow up questions.? In the Query, I'm using two Fields ("Tester" & "Test was:"). The Tester field obviously contains all the the testers contributing to the database; but the Test was: field contains three options (Bad, Good, & Good w/ Notes). My question...how can I single out the Top 5 Good tests, and the Top 5 Bad tests based on the number submitted? If you only have two fields, how are you deciding what represents the "Top 5"? My second question...I was unable to select the "descending" option while in Design View. I can see it on the Home tab, however it's not open for selection. Am I completely off base on that? When I use design view of a query, one of the rows in the bottom pane is Sort: Thank you again for your assistance! This is a great lesson for me. V/r RasJr. Regards Jeff Boyce Microsoft Office/Access MVP |
#6
|
|||
|
|||
How do I create a Top 5 percent report?
I'm still not visualizing how you'd get from the data you have to the report
you want. Are you saying that your definition of how "good" a tester is is based on a comparison between the number of "good" tests they have and the number of "bad" tests? Wouldn't that require first finding these numbers for each person, then doing the calculation (you don't say HOW you calculate this), THEN finding the top 5 with the best "score"? Regards Jeff Boyce Microsoft Office/Access MVP "RasJr." wrote in message ... If you only have two fields, how are you deciding what represents the "Top 5"? I'm not sure...What I'm wanting is a report that will show the Top 5 Good testers with the least amount of "Bad" tests to their name, and (hopefully in the same report) the Top 5 Bad testers with the most "Bad" tests to their name. I created a pie chart using the "Tester/Test was:" Query, and assumed that if tweaked a bit could display a Top 5 Good/Bad report. One thing that I would think to add would be the "ID" feild, which holds each tester's individual ID #...but again, I'm a novice with Access. V/r RasJr. "Jeff Boyce" wrote: see comments in-line below... "RasJr." wrote in message ... Thanks, Jeff! I was able to set the TOP property to 5 and it worked, but I have a couple of follow up questions.? In the Query, I'm using two Fields ("Tester" & "Test was:"). The Tester field obviously contains all the the testers contributing to the database; but the Test was: field contains three options (Bad, Good, & Good w/ Notes). My question...how can I single out the Top 5 Good tests, and the Top 5 Bad tests based on the number submitted? If you only have two fields, how are you deciding what represents the "Top 5"? My second question...I was unable to select the "descending" option while in Design View. I can see it on the Home tab, however it's not open for selection. Am I completely off base on that? When I use design view of a query, one of the rows in the bottom pane is Sort: Thank you again for your assistance! This is a great lesson for me. V/r RasJr. Regards Jeff Boyce Microsoft Office/Access MVP |
Thread Tools | |
Display Modes | |
|
|