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.