Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started