Success!!!!!
After many hours of trial and error I finally have a query that gives me the desired results. What I had to do was create 2 querys.
Query1:
Code:
SELECT [LastName] & ", " & [FirstName] AS [Student Name], tblAttendance.AttendanceDate AS Attendance, GetDays([Enter Start Date],[Enter End Date],"46") AS [Total Classes], Members.Active
FROM Members INNER JOIN tblAttendance ON Members.MemberID = tblAttendance.MemberID
GROUP BY [LastName] & ", " & [FirstName], tblAttendance.AttendanceDate, GetDays([Enter Start Date],[Enter End Date],"46"), Members.Active
HAVING (((tblAttendance.AttendanceDate) Between [Enter Start Date] And [Enter End Date]) AND ((Members.Active)=Yes));
Query 2:
Code:
SELECT DISTINCTROW qryAttendanceByRange.[Student Name], Count(qryAttendanceByRange.Attendance) AS [Count Of qryAttendanceByRange], qryAttendanceByRange.[Total Classes], qryAttendanceByRange.Active
FROM qryAttendanceByRange
GROUP BY qryAttendanceByRange.[Student Name], qryAttendanceByRange.[Total Classes], qryAttendanceByRange.Active
HAVING (((qryAttendanceByRange.Active)=Yes));
This works great, however, if anyone knows of an alternate / better solution please reply.
Regards,
Chris