J
jacqueline
We have an Access 2000 frontend and an SQL server backend for the tables...
The database houses ~ 1700 medical school applications.
1 main Student form...that has about 10 links to that individual applicant's
history (ie: employment history, academics, residency, etc...)...the links
just bring up the info for the individual applicant shown on the main Student
form.
PLUS...there is a separate form from where all the main acknowledgement
letters/reports are run.
The Administrative office ONLY wants to work with a subset of these
applicants (~700 applicants) for running most of the reports.
....It would be based on 2 criteria...
1. want records where the Application_Submitted checkbox is YES (in
dbo_CompletedSections table)
2...where Fee_Paid checkbox is Yes. (in dbo_AdditionalInfo table)
The admin office enters this main Student form and the Acknowledgement form
through a Main Switchboard page.
Could someone please tell me how to filter a database in order to only work
within a subset of records?
The database houses ~ 1700 medical school applications.
1 main Student form...that has about 10 links to that individual applicant's
history (ie: employment history, academics, residency, etc...)...the links
just bring up the info for the individual applicant shown on the main Student
form.
PLUS...there is a separate form from where all the main acknowledgement
letters/reports are run.
The Administrative office ONLY wants to work with a subset of these
applicants (~700 applicants) for running most of the reports.
....It would be based on 2 criteria...
1. want records where the Application_Submitted checkbox is YES (in
dbo_CompletedSections table)
2...where Fee_Paid checkbox is Yes. (in dbo_AdditionalInfo table)
The admin office enters this main Student form and the Acknowledgement form
through a Main Switchboard page.
Could someone please tell me how to filter a database in order to only work
within a subset of records?