Margarita also wants to show the number of patients participating in recent health studies at the clinic,
Fantastic news! We've Found the answer you've been seeking!
Question:
Margarita also wants to show the number of patients participating in recent health studies at the clinic, including the Hypertension study. Create a query in Query Design View as follows:
- Add the Patients, Participants, and Studies tables to the query.
- First add the StudyName field from the Studies table to the design grid, and then add the PatientID field from the Patients table.
- Add criteria to select only those records where the StudyName field is Arthritis or Cholesterol or Diabetes or Hypertension.
- Add a Total row to the query.
- Group the query by the values in the StudyName field and count the values in the PatientID field.
- Save the query using RecentStudies as the query name.
- Display the query in Query Datasheet View to view the results and then close the query.
Posted Date: