Please can I have assistance with making 3x different queries:
1) I want to know what percentage of active patients have an email address recorded. Let's consider active as any patient that has attended in the last 2 years. I imagine this is achieved by two reports, one looking at the number of active patients and another looking at the number of active patients with an email address.
2) I want to know how many active patients are registered to a particular dentist. Again, let's consider active as attending within the last 2 years.
3) I want to generate a list of patients booked in with a specific dentist for exams, but who are registered to another specific dentist.
Thanks in advance,
Many thanks for your post, to make this easier to read I will split my responses into 3.
1) Percentage of active patients that have an email.
As you highlighted this will be 2 different queries, we need to firstly create a query for any patient who has had a completed appointment in the past 2 years
The above will show you all patients that have, if you run the query the number will be at the bottom right. Make a note of this number
We then need to add the email field into a different query, follow the below.
This is then only including patients who have been seen in the past 2 years with an email address, use the number at the bottom right and work out the percentage from there.
Onto the 2nd query.
2) Active patients registered to a dentist.
The above will then show you a list of patients registered to that dentist who have had an appointment in the last 2 years.
In regards to the 3rd query, I am reading this as future appointments. If this isnt the case please let me know.
3) List of patients booked in for exam, but registered to another dentist
Please create the query below:
The query will then each time ask you to specify the registered dentist and then the dentist they are seeing in the future. Ie. registered to dentist A but seeing dentist B.