unique records by team

[juster21]

All,
I have a table with team names, employee ID, month/year combos and a quality score.
I need to calculate the total count of employees that have a quality score within a specified timeframe (March 2009) and have the results by team name.

See example:
Team EmpID MonthYear Quality
A.......1.......March2009.....99
A.......2.......March2009.....98
A.......3.......March2009
A.......4.......March2009.....100

B.......5.......March2009.....100
B.......6.......March2009.....99
B.......7.......March2009

Results:
A = 3
B = 2

 

[james_lankford]

select
Team, count(*)
from your_table
where
(
  (  
    [Year] = 2009
  )
  and
  ( 
    [Month] = 'March'
  )
  and 
  (
    Quality is not null
  )
)
group by 
Team

 

[juster21]

nope...that returns no results

 

[james_lankford]

MonthYear is one column ?
what's in the Quality column is there is no Quality ?
null ? 0 ?

this works for me if Quality is null when no Quality is entered

select
Team, count(*)
from your_table
where
(
  (  
    MonthYear = 'March2009'
  )
  and 
  (
    Quality is not null
  )
)
group by 
Team

 

[juster21]

opps!!! my apology..an error on my part...works great!