Using Query to trim down multiples?

[galvinjaf]

Good Morning,

I have a list of Supervisors that score 5 random calls for each Telephone Operator. I have set up a query to figure out which Telephone Operators have had a 5 Message review completed and by who. Basically, I want to be able to run the query and see which Operators have had a review completed.

Because each Operator has 5 calls reviewed, their Operator name and Completed by appears 5 times along with the pay period ending date. (See attached pic labeled 5 Message Query).

I'd like to run the query and it give me information that looks like a sample one I did in excel (see attached pic Sample 5 Message).

Any ideas?

 

[arnelgp]

use aggregate function or select distinct values.

 

[galvinjaf]

While I didn't know what an aggregate function was (I googled it...) I was able to figure out how to create one thanks to your response. My query came out exactly how I wanted. Thank you.