Adding a Count function to current select statement

[johnson8809]

I am trying to add a count of the associates that are absent from an attendance table. I can't seem to get it to work. Anyone have any ideas. It would be greatly apprciated. Thank you. The statement that I have is below. Minus the lame count function that I tried......


SELECT tblAttdncInfo.SbmtName AS MGR, tblAttdncInfo.AssocName,
tblAttdncInfo.Absence AS Reason, tblAttdncInfo.Dte
FROM tblAttdncInfo
WHERE (((tblAttdncInfo.Dte)=Date()))
ORDER BY tblAttdncInfo.AssocName;

[orange]

w3schools SQL has several tutorials on SQL

see Count

[johnson8809]

Thank you.