R
richardwo
Hello,
I have a query with two fields, Patient Name and FollowUp. FollowUp is a
"Yes/No" field and I would like to show a list of patients with the number of
followUps they had.
This is what I did:
Field: Name FollowUp
Table: tblClinic
Total: Group By Count
Sort:
Show:
Criteria:
The above query returns a list of patients and the total number of followups
they each had, BUT, includes patients who had "No" in the FollowUp field e.g.
John Smith had 3 visits to a clinic but only 2 followups but the query
returns a value of 3 in the FollowUp field.
Is there anyway of calculating the number of actual followups for each
patient i.e. the number of yes's in the followup field.
Thank you in advance. Rich
I have a query with two fields, Patient Name and FollowUp. FollowUp is a
"Yes/No" field and I would like to show a list of patients with the number of
followUps they had.
This is what I did:
Field: Name FollowUp
Table: tblClinic
Total: Group By Count
Sort:
Show:
Criteria:
The above query returns a list of patients and the total number of followups
they each had, BUT, includes patients who had "No" in the FollowUp field e.g.
John Smith had 3 visits to a clinic but only 2 followups but the query
returns a value of 3 in the FollowUp field.
Is there anyway of calculating the number of actual followups for each
patient i.e. the number of yes's in the followup field.
Thank you in advance. Rich