querys

[babysilvertooth]

I am trying to pull a report for icoomplete notes, under reports it shows Daily, but is there a way to pull them going back 6 months, etc.?

[wjstarck]

Hello-

Give this a whirl, I think this will do what you want. Just copy and paste, and change the dates to suit your needs.

Code: Select all

SELECT procedurelog.ProcDate,
CONCAT(CONCAT(patient.LName,','),patient.FName) AS Patient,procedurecode.ProcCode,procedurecode.Descript,
procedurelog.ToothNum,procedurelog.Surf
FROM procedurelog,patient,procedurecode,procnote n1
WHERE procedurelog.PatNum = patient.PatNum
AND (procedurelog.ProcDate >= '2011-03-01' 
AND procedurelog.ProcDate <= '2011-03-31')
AND procedurelog.CodeNum = procedurecode.CodeNum
AND procedurelog.ProcStatus = 2
AND procedurelog.ProcNum=n1.ProcNum
AND n1.Note = ''
ORDER BY procedurelog.ProcDate

[jordansparks]

I think it already shows all incomplete reports regardless of how far back they go. The reason it's under daily is so you stay on top of them.