Re: Top Ten Filter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

fapa,
Using the query design grid, create a Totals query to sum each employees shares, and
sorts that result by SumofShares Descending. When that works OK, then simply use the Top
combo (10) to see the top ten.
EmpNo Last First Shares
GroupBy GroupBy GroupBy Sum
Desc
How you decide to "display" this data to the user is up to you. The above query could
feed a pop-up form, report, list box,... etc...

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."


"fapa via AccessMonster.com" <u19477@uwe> wrote in message news:6dca00efc0ea7@xxxxxx
Hey Everyone

Wondering if someone can help...

I've got a form that shows a list of employees in the company, and the number
of shares each employee has been issued. Each employee is even a certificate
(share_cert_number) with the number of shares their allowed.

I'm trying to create a sort of Top 10 employees list which is defined as
employees with the most shares. At present, i can create a top 10 list
however many employees names reappear on it as they have been issued lots of
share certificates with many shares. What i'd like is a list which shows 10
individual employees with the TOTAL value of their shares (hence total value
of all share certs issued to them) can someone help on how this can be done?

the fields on the form are:
Employee_number
first_name
Last_name
no_of_shares

thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200702/1



.

Relevant Pages

  • Re: Help with query counting unique records???
    ... Change the query to a summary totals query. ... > I have an Access db that keeps track of employees and dates that tasks are ... > completed tasks and not the number of employees for all the tasks. ...
    (microsoft.public.access.queries)
  • Re: Date Criteria Correct?
    ... the employees that have call in dates show up on my query and only for the ... <MS ACCESS MVP> ... totals to drop off 12 weeks ago based on the first date the employee ...
    (microsoft.public.access.queries)
  • Re: Provide Average # of years of employees in an entire company
    ... of years our employees have been employed. ... Then take that calculated field and average ... Create a Query based on your employee table. ... and use Avg on the Totals ...
    (microsoft.public.access.queries)
  • Re: Provide Average # of years of employees in an entire company
    ... of years our employees have been employed. ... Then take that calculated field and average ... Create a Query based on your employee table. ... and use Avg on the Totals ...
    (microsoft.public.access.queries)
  • Re: Help with query counting unique records???
    ... The reason I need the count of the employees is that some months there are ... > Change the query to a summary totals query. ... >> completed tasks and not the number of employees for all the tasks. ...
    (microsoft.public.access.queries)