Open Dental Forum

Hello, I am trying to see if Open Dental will work for one of our offices.

I am looking for a way to run a report that will tell me the total patient encounters for a specific time period. Example :

How many Patients were seen between June 1, 2009 - and June 1, 2010?

Thank you in advance for your answer

Danielle

Your post seems to imply two different questions. The first being patient "visits" (appointments), the second being unique patients. Below are two different queries I use:
1) Visits
SELECT count(distinct appointment.AptNum) as Visits FROM appointment
WHERE appointment.AptStatus=2
AND appointment.AptDateTime >='2009-06-01'
AND appointment.AptDateTime <'2010-06-01'

2) Patients
SELECT COUNT(DISTINCT PatNum) FROM procedurelog
WHERE ProcStatus=2 AND
ProcDate>='2009-06-01' AND
ProcDate<'2010-06-01'