I have a subform where I enter the date someone attends a meeting and then this information flows into my table "Meeting Dates". I want to take this information from Meeting Dates and count the number of times an individual attends a meeting during a specific year and then have this data fill in the appropriate field in my "Attendees" table. For instance: AttendeeID = 64, 2020 Attendance = 3
"Attendees" Table: Primary Key = AttendeeID, Field to drop data into "2020 Attendance"
"Meeting Dates" Table: MtgDates, AttendeeID
I found something online and thought it could work.
SELECT T1.Employee_ID,
(SELECT COUNT(*) AS CNT FROM Employees AS T2 WHERE T2.Manager_ID =
T1.Employee_ID) AS Supervised_Count
FROM Employees AS T1;
Now, if I could just figure out where to plug my data into.
SELECT MEETING DATES.AttendeeID,
(SELECT COUNT(*) AS CNT FROM XXXX WHERE XXXX = XXXX) AS 2020 Attendance
FROM XXXX AS XXXX
HOWEVER.. if this isn't going to work let me know what might. : )