How do I get an avg and a count in a query

[okie76]

Hello,



First off I am very new to access and learning "on my own" as I go, so I will probably be asking lots of questions here the next few months

My first question: In my query I have 2 columns. Column 1 is the Technician names and the names aren't really names but instead a 5 digit number followed by the company that the technician works for (example "98701 - Slapstick, 98702 - Slapstick, 98703 - Slapstick and so forth") these tech names get repeated many times as customers turn in complaints or kudo's, thus generating a new record. Column 2 is a number that will always be either "nothing,1,2,3,4,5" that corresponds to how well or poorly a technician did. What I need help in doing is making a Column 3 and 4 with column 3 counting the number of times that "the first 5 values in column 1 of the same technician" (IE how many times 98701 appears, how many times 87702 appears) appears in the table and column 4 giving me an average of all the numbers in column 2.

Any help would be greatly appreciated, but remember I am learning still. Thanks in advance.

[June7]

Sounds like an aggregate (GROUP BY) Totals query. Open query in design view, click Totals button on ribbon Design tab. Set parameters as appropriate. Access Help has more guidelines on building queries with the designer.