Using Access 2007...
I have a data table with appointment dates, appointment statuses, patient names, a yes/no field and some other data not currently being used for this query. I am trying to use a query to aggregate data by week or month (I will be doing both eventually, but I am starting with weekly) to give me a numerator and a denominator based on the yes/no field.
The first field in my query normalizes the appointment date to the date on the first day of the week (this is working as expected). The second field is a count of patient names, then I have two non-displayed fields, one for a filter on yes/no, and the other for a filter on appointment status. There are two possible appointment statuses that I want included in the query result, but I want the counts of patient names combined together for both appointment statuses. Currently the counts are separated by appointment status. I've tried two different things for the filter criteria:
"CHECKED OUT" Or "INPATIENT APPOINTMENT"
and
Not "IsNull" And Not Like "*Missing*" And Not "ACTION REQUIRED"
Both of these filter criteria give me the same result.
How can I get the counts of patient names combined together for both appointment statuses?
-Ben