Combining multiple queries in one in Access
- by Arlen Beiler
I have two queries that I want to combine into one in Microsoft Access 2003.
SELECT AttendanceQuery.AttendDate, Count(*) AS Absent
FROM AttendanceQuery
WHERE (((AttendanceQuery.Present)=False))
GROUP BY AttendanceQuery.AttendDate;
SELECT AttendanceQuery.AttendDate, Count(*) AS Enrollment
FROM AttendanceQuery
GROUP BY AttendanceQuery.AttendDate;
The one shows the total records for each date, the other shows the ones that are marked absent.
