Quer related to Count Function

Joined
Aug 18, 2009
Messages
3
Reaction score
0
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;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top