Not sure what to label this as.

[Guest]

My problem is that I am making a database for the honors society chapter at
the college where I work. The advisor in charge of this has asked me to do
something that I do not know how to do. She wants the database to
automatically take students who are in the chapter who graduate to be moved
to another table aptly named alumni.

To simplify this hopefully; I need the database to look at the year and
semester when the student graduates and move them into the alumni table at
the end of the semester they graduate. And assuming this is possible, this
has to happen when the database is running.

The following data is what I am using to run other queries. Its all pretty
strait forward. Graduations take place only during the Fall and Winter
semester so Spring and Summer are not included.

Semester and Year
Fall – FA2006
Winter – WI2007

Semester Run Times
Fall – Last week in August – Second week in December
Winter – Second week in January – First week in May

 

[Guest]

its pretty easy.

practice your query skills and be sure that you can capture all the
appropriate records via a standard query.

then you can option that query to be an append query to the Alumni Table

next you can re-option that query to be a delete query from the Chapter Table

If you are not familiar with Append and Delete Queries - check them out at
Help or Microsoft web site - they are standard features. Obviously it might
make sense to practice on a copy of the table(s) rather than the real thing...

 

[MikeR]

My problem is that I am making a database for the honors society chapter at
the college where I work. The advisor in charge of this has asked me to do
something that I do not know how to do. She wants the database to
automatically take students who are in the chapter who graduate to be moved
to another table aptly named alumni.

To simplify this hopefully; I need the database to look at the year and
semester when the student graduates and move them into the alumni table at
the end of the semester they graduate. And assuming this is possible, this
has to happen when the database is running.

The following data is what I am using to run other queries. Its all pretty
strait forward. Graduations take place only during the Fall and Winter
semester so Spring and Summer are not included.

Semester and Year
Fall – FA2006
Winter – WI2007

Semester Run Times
Fall – Last week in August – Second week in December
Winter – Second week in January – First week in May

Why not add a field to the chapters table to flag it as an alum? Yes/No or date
of graduation? The real question to me is what triggers the switch? I don't
think just because a date has passed, a student can be assumed to have graduated.
Mike