List of Emergency patients who never had cleaning done

[SMathew]

Is there a report or query available for those emergency new patients in a date range who never had cleaning done?

[Tom Zaccaria]

Try this

/*217 Patients who need followup-Patients with a procedure in a given list completed in date range but no other procedures on another date,
apts are counted by procedures summed by date, so it works even if you so not use appointments*/
SET @FromDate='2016-1-01' , @ToDate='2016-12-31';
SELECT patient.PatNum, DATE_FORMAT(MAX(ProcDate),'%m/%d/%Y') AS 'LastVisit', COUNT(DISTINCT procedurelog.ProcDate) AS '#Apts'
FROM patient,procedurelog
WHERE patient.PatNum IN
(SELECT DISTINCT p.PatNum FROM patient p
INNER JOIN procedurelog pl ON p.PatNum=pl.PatNum
INNER JOIN procedurecode pc ON pl.CodeNum=pc.CodeNum AND pc.ProcCode IN('D0140')
WHERE pl.ProcStatus='2')
AND procedurelog.PatNum=patient.PatNum AND procedurelog.ProcStatus=2 AND patient.PatStatus=0
GROUP BY procedurelog.PatNum
HAVING (MIN(ProcDate) BETWEEN @FromDate AND @ToDate) AND COUNT(DISTINCT procedurelog.ProcDate)=1
ORDER BY patient.LName, patient.FName;

drtmz