Re: Need HELP.. New To Access how to condence a report and making it a monthly report
Try a totals query
SELECT call, Sum(attended) AS TotalOverall, Sum(IIf(AttendedField = True, Attended, 0)) AS TotalAttended, Sum(IIf(DidntAttendField = True, Attended, 0)) AS TotalDidNotAttend
GROUP BY call
Microsoft Access MVP 2007-2019
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.