Group by in MS Query

[010301]

hi there i have the following code but need the results so it groups the agents names so i dont get mutiple entrys of one agent in my data.

i have the following code

SELECT `Weekly Counts by Team Name`.`Date of Call`, `Weekly Counts by Team Name`.`Agents Name`, `Weekly Counts by Team Name`.`Team Manager Name`, `Weekly Counts by Team Name`.Method, `Weekly Counts by Team Name`.Outcome, `Weekly Counts by Team Name`.CountOfOutcome
FROM `Weekly Counts by Team Name` `Weekly Counts by Team Name`
WHERE (`Weekly Counts by Team Name`.`Date of Call` Between ? And ?) AND (`Weekly Counts by Team Name`.`Team Manager Name`='managers name)

i would be greatful if someone could help me ...

 

[combo]

[tt]SELECT DISTINCT ...[/tt]

combo

 

[010301]

were would i put that within my code, im new to all this ya see...

 

[combo]

Just add DISTINCT after SELECT in your sql string.

combo