cancel
Showing results for 
Search instead for 
Did you mean: 
Joannekear05
Canine II

Report

How do I create a report to show me under 18's that have not been into the practice for 12 months or more?

0 Kudos
Reply
1 Reply
kimorr
CS Dental Employee
CS Dental Employee

Re: Report

Good Morning!

To get the information you requested follow these steps:

  1. From the Patients Selector window click Query Wizard
  2. Click New Query.
  3. Click Start and then Next.
  4. Click specify Attributes.
  5. From Fields Double click Date of Birth.
  6. Under the operator column, click on the line and from the drop down select Is Later Than.
  7. Under the Value column for DOB, click ellipse (3 dots),Select Relative to time, In the past and enter 18 at years.
  8. From Fields, double click Last Completed Appointment.
  9. Under the operator column, click on the line and from the drop down select Is Earlier than.
  10. Under the Value column for Last Completed Appt, click the ellipse, Select Relevant to current time, In the past and put in 12 in Months. Or you could put in Years if you so wish.

This report will show you under 18's not seen in xx months or years.

I hope this helps.

Kind regards

Kirsty