My ultimate goal is to have a three reports to show specific data based on my query(ies).
My database contains an update query (Qry: UpdateQryAttendFrm) that appends to a table (AttendanceAppendTable). My RptMtgAttendanceALL report does exactly what the name implies, it pulls all of the attendees for each of the three meeting types "SNF Coalition", "ALF Coalition" and "ALF/SNF Coalition" into one report from my QryMtgAttendance query. I would like to take this a step further and pull each meeting type separately; one report for "SNF Coalition" meetings, one report for "ALF Coalition" meetings, etc. I tried filtering my query using the WHERE clause, but I can't get it to work. I feel like I am missing a JOIN somewhere, but I can't seem to work that out. I also tried filtering in the report but that didn't work either.
I'm going to defer to the more experienced to determine if it is better/easier to put the filter in the query or within the report. So, with that being said, I'll take your advice on whether it's better to filter at the query level or the report level (which I couldn't get to work either).
If at the query level, then please advise how I can accomplish this. I have attached my db so you can see my objects to explain how I would filter within the query. Everything I have tried brings back zero records.