Waiting List

[Jim Nessl]

We have many applicants and a set number of slots for a
course. There are 8 courses and, based on the date of
application, reports(letters) that notify applicants of
acceptance in a course, are sent. If there is no
response, from the applicant, letters are sent to the
next applicants on the waiting list to fill out the
slots. I am first having trouble using a variable
for "Top N" or in VBA to limit the number of reports to
print. Also a flag must be set to remove an applicant
from the waiting list after a letter is printed.

 

[Duane Hookom]

You haven't stated anything that describes which applicants are selected and
which aren't. Is there a field that identifies the order of registrations or
something?

I would use some method outside of the report (maybe before or after you run
the report) to record the status.