Software

Ask something
Discussion Locked

Counting A Field

0 helpful
3 replies

by borginva

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by syscokid

Create a crosstab query using the query wizard. Make ClosedUser your row header and Priority your column header, and select Count as the value to enter at the intersection of each column and row.

by borginva

I did that and it gave me an error. I made the ClosedBy as Row Heading and the Priority as Column heading. I made both set up to Count. When I execute it, Access says the one with Column Heading (Priority) has to be set for Group BY. SO I did that and the next error was:
To create a crosstab query, you must specify one or more Row Headings options, one Column Heading option, and one Value option.

Then I did some playing around and found that if I made those both as Group By and added another field for priority, made that Count and as a Value, it works.

Now it works, thanks.

This discussion is closed to new replies.