Quer related to Count Function

[tandon]

Hello,

Below is th equery which i am using but m not able to get the desired result,
wanted to count data in Call_Type Field (column) as equal to either New,or Repeat. Please Help!!!




SELECT sales.Region , sales.FLM , Count(sales.Call_Type) AS TotalCalls
FROM (SELECT DISTINCT Region, FLM, Call_Type FROM sales) AS TotalCalls
GROUP BY sales.Region, sales.FLM
ORDER BY sales.Region, sales.FLM;