This database and set of queries will allow you to look for students that did a change of campus location in several ways,  i.e.. sem to sem or sem to curr or sem to future.

STEP 1: Determining the Right Query

To begin, you need to choose which query you need to run:

qry Previous To Future Change of Location (SP to FA)

This is the type of query you will run most often.  It is run during the summer semester and tracks students that have made a change of location between Spring and the upcoming Fall.

qry Current To Future Change of Location (FA to SP / SP to SU)

This query is run during either the Fall or Spring semesters to determine change of location students from the current semester to the upcoming semester.  This query can also be used to determine SU to FA.

qry Previous To Current Change of Location (FA to SP / SP to SU)

This query is run during either the Spring or Summer semesters to determine change of location students from the previous semester to the current semester.  This query can also be used to determine SU to FA.

When you have determined which query to run, highlight it, and select the DESIGN button to the right of the query.

STEP 2: Editing Your Query
After you push the DESIGN button, you will be see the design of the query, as seen below (Previous to Future query used for example):

* note: DBO_STUDENT_SEM_F indicates DBO_STUDENT_SEM_FUTURE.

STEP 3: Filling in the Criteria & Running the Query
Now fill in the criteria specific to your needs as shown above.  Close the query design when complete, re-highlight the query, the select the OPEN button to the right of the query.

STEP 4: Viewing Your Results
Your results are now stored in a table titled either
tbl Previous to Future Change of Location,
tbl Previous to Current Change of Location, or
tbl Current to Future Change of Location.

You can find your table by selecting the tables tab on Access.

Example of results in a table:

* note: name and student number fields were excluded for privacy.