need appointment tickler for several kinds of appts

[Guest]

I have a table of patient names & ID numbers. Each patient is seen for one
or more of four types of recurring appointments - for each type of visit
there is a different due date for next visit (e.g. Lab work: 3 months;
doctor: 1 month; Xray: 6 months, etc. One visit can be for several
purposes.) I have a table with each record for date of visit, and a yes/no
for each type of visit this was, any or all of four types. Also created four
separate ticklers (queries) that tell me when next Lab is due, xray is due
etc. We would like a tickler list report that would gather info from all
the four appt types, and list in order of date who we need to schedule for
next week to comply with the next-visit-due, and for what type of visit.
Getting all the four separate tickler lists into one is what is stumping me.
Access 2000

 

[Danny J. Lesandrini]

I may not have read close enough, but it seems like you want a UNION query.

SELECT PatientID, VisitDate, VisitNote WHERE Type=1
UNION SELECT PatientID, VisitDate, VisitNote WHERE Type=2
UNION SELECT PatientID, VisitDate, VisitNote WHERE Type=3
UNION SELECT PatientID, VisitDate, VisitNote WHERE Type=4