Subtotals and Ranking

[Guest]

I am trying to first subtotal the employees who had an entry, then count how
many they completed of those entries, then rank them according to their
manager.

Any ideas?

Thanks and Take Care!

 

[Guest]

Sorry, Leo, I don't see enough info to give a good answer. It sounds like a
query could accomplish this, but I would need to know what an entry is and
how you know they are completed.

 

[darkroomdevil via AccessMonster.com]

I am trying to first subtotal the employees who had an entry, then count how
many they completed of those entries, then rank them according to their
manager.

Any ideas?

Thanks and Take Care!

Need more info ...

Making some assumptions here
-we are not counting the number of employees, but counting the number of
records that the employee is a part of ....

Table1 = tblActivity (whatever table the employees have an entry in that you
are counting)
Table2 = tblEmployee
Table3 = tblManager
Is the manager the manager just for the task, thus linked to tblActivity or
is the manager always the manager of the employee, thus linked to the
employee table?

Or is your structure different?

These are the things you will most likely end up doing....

Making a query, when you click Design in the Query Database Window, Access's
QBE grid pops up .. in this you will:

-add the tables you are useing and drag a field in one table to another to
create relationships between the fields
- In the Menu >>> View>Totals to turn totals on in the query, then enter
GroupBy or Count or whatever is appropriate
- In the criteria row enter criteria such as ... Is Not Null ... to refine
the query to the records you want.
- In the Sort Row use the sort order option for the records you want to sort
on

This should get you started
Roger