This is working great for count and monday-count, I just need to get it to show 0's for people with no events
I'm learning as I go.. Do you write the SQL manually or use the query Design in Access?
Code:
SELECT Name, Count(*) AS Events, Sum(IIf(Weekday([Events].[EventDate])=2,1,0)) AS CountMon
FROM (SELECT Attendees, Name, Access, EventDate FROM Events, Security WHERE (InStr([Attendees],[Name])>0) AND (Access="Attendee") AND (EventDate >= Date())) AS Q1
GROUP BY Name
ORDER BY Count(*) DESC , Name;