How do I do the following:
- I have a 2007 Access Database with 1000 rows.
- Each row represents a Human Resource Issue at work.
- Each one of the 1000 rows includes the name of the employee who committed the HR offense.
- In total, there are 100 unique names in the 1000 rows (some names repeat themselves).
How can I make a bar graph in Access 2007, that will show only the 10 employees with the most HR offense, and their number of offense, rather than the 100 employees, and their number of offenses?
Thanks!!!!!!!