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 ...

SELECT DISTINCT ...

combo

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

Just add DISTINCT after SELECT in your sql string.

combo