Access 97

A

Arlene

How do I cut and paste records from one table to another within the same
database?

My situation is that I have a table for current students and a table for
graduates. When some current students graduate, I need to take them out of
the current student table and put them into the graduate table.

Any help would be most appreciated, and I'd love an e-mail response at
[email protected].

Thanx!
Arlene
 
F

fredg

How do I cut and paste records from one table to another within the same
database?

My situation is that I have a table for current students and a table for
graduates. When some current students graduate, I need to take them out of
the current student table and put them into the graduate table.

Any help would be most appreciated, and I'd love an e-mail response at
[email protected].

Thanx!
Arlene
Click to expand...

No need to cut and paste.
No need for a separate Graduate table.

Simply add another field [Graduated] to the Student Table.
It can be a Yes/No check box field.
When a student graduates, set the field to Yes (Checked).

You can then filter the table to show only active students or only
graduated students or ALL.
 
Top