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
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:
I hope this gives you the information you require. If you have any problems then do please get back to me.