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

Hygiene recalls

I am trying to get a query or report with a list of patient due for a hygiene appointment. I've been with support but they don't know how to do that and have referred me to the Exchange. Please, I would like to be able to select patients with the last hygiene appointment between 2 dates and no pending appointments. Thank you in advance

0 Kudos
1 Reply
CS Dental Employee
CS Dental Employee

Re: Hygiene recalls

Good Afternoon

Please try the following query.

To find all patients who had an appointment with the hygienist between 2 dates and haven’t got a pending appointment:

  1. Open Query Wizard
  2. Click ‘New Query’ then ‘Start’
  3. Click ‘Next’
  4. Select ‘that don’t have an appointment with a status of [Appointment Status]
  5. Click ‘Specify Criteria’
  6. Select ‘Pending’ in the Value Column and then click ‘OK’
  7. Now select ‘that have had an appointment’ and click ’Next’
  8. Tick the box next to ‘with [User]’ and click ‘Specify Criteria’
  9. Select the name of the Hygienist in the ‘Value’ column and click ‘OK’
  10. Tick the box next to ‘between [no date specified] and [no date specified]
  11. Click ‘Specify Criteria’
  12. Tick the ‘Ask’ box and then ‘OK’ on the window that appears do this for both the rows
  13. Click ‘OK’
  14. Click ‘Finished’ and save the query

I hope this gives you the information you require.  If you have any problems then do please get back to me.

Kind regards


0 Kudos