Count unique values then summarize

[Jarvis]

I have a database that assigns tasks to workers.

Field 1 = TASK DESCRIPTION

Field 2 = WORKER NAME

I would like to generate a list of how many tasks have been assigned to each worker and I would like to have this list sorted in descending order, according to who has the greatest number of tasks. As tasks are added and assigned, I would like this list to dynamically refresh itself.

Does anybody have a suggestion how to do this?

Thanks,

Jarvis

[aaa]

Hi, Jarvis!

Look attachment! Such?

Worker_Tasks.zip

Edited December 23, 2005 by Guest

[Jarvis]

aaa,

Thanks a lot! That is just what I was looking for.

I'm not exactly sure how you did it, I'll have to stare at it a while.

I notice that you used a new window, and this is something I have never investigated.

Thanks a lot again!

Jarvis