Query to return total number of dates from this year? 1

[NFLDUser]

I have a table called PatientList that has a field called frst_visit that indicates when someone becomes a customer. How could I return the total number of customers that dates are from the current year, one year previous and 2 years ago. So I am looking to return 3 values.

 

[r937]

select sum(iif(year(frst_visit)
             = year(date()),1,0))
           as visits_this_year
     , sum(iif(year(frst_visit)
             = year(date())-1,1,0))
           as visits_last_year
     , sum(iif(year(frst_visit)
             = year(date())-2,1,0))
           as visits_prev_year
  from PatientList

r937.com | rudy.ca

 

[NFLDUser]

Perfect...THANKS