Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    14

    Question Unanswered: Calculation of Percentage

    Hi,
    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.

  2. #2
    Join Date
    Jun 2003
    Posts
    21

    Re: Calculation of Percentage

    Originally posted by dmly
    Hi,
    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.
    Think this can be done in Access, but seen the group we're in you're using MySQL. Don't think it can be done in MySQL (<= 4) because it doesn't support the use of subqueries.

    Niels

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •