General discussion
August 14, 2002 at 03:40 AM
borginva

Counting A Field

by borginva . Updated 24 years, 1 month ago

I have a table called CALL. I have fields ClosedUser and Priority.
I am trying to do a query or report to give me a list of each user and how the total of each priority they closed. For example:
USER P1 P2 P3
Bill 7 3 8
Sue 15 0 98

I do not know much of access. I tried using COUNT but it was giving me errors.
Please help.

This discussion is locked

All Comments