“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