select groupfield
,Sum(IIf(satcomments="Yes" and daily life="Yes",1,0)) AS dailycountyes, Sum(IIf(satcomments="No"and daily life = "Yes",1,0)) AS dailycountno, Sum(IIf(satcomments="Partly"and daily life = "Yes",1,0)) AS dailycountpart
from visit table
group by groupfield
I've also tried
If...