Does anybody know how to solve this problem?

I have a table employees(emp_id, branch, num_error)

I need to group the table by branch, then by emp_id. Then, I need to calculate the percentage of a particular employee over his branch and over the entire company.

I'd like to have some advices in MS Access and/or Lotus Approach please.

Please help!. Thank you for your time.