Scheduler Reminders

“Is there an easy query that would simply print all the scheduler reminders off the patient info form p.2?”

SELECT 
   LastName, 
   FirstName, 
   ID, 
   NoSchedReason
FROM 
   sos.Patients
WHERE 
   Flag = 0
ORDER BY 
   LastName, 
   FirstName
The Flag condition limits to active patients. If you want only those that have a reminder entered, add another condition. 
Note that the '' at the end of line three is two apostrophes, not a single quotation mark.
SELECT 
   LastName, 
   FirstName, 
   ID, 
   NoSchedReason
FROM 
   sos.Patients
WHERE 
   Flag = 0 
   AND NoSchedReason <> ''
ORDER BY 
   LastName, 
   FirstName
 Finally, the one below combines the name and id into a single field to make the output a bit cleaner:
SELECT 
   LastName+', '+ FirstName+' / '+ ID AS "Patient", 
   NoSchedReason
FROM 
   sos.Patients
WHERE 
   Flag = 0 
   AND NoSchedReason <> ''
ORDER BY 
   LastName, 
   FirstName

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.