Access 97

[Guest]

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
(e-mail address removed).

Thanx!
Arlene

 

[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
(e-mail address removed).

Thanx!
Arlene

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.

 

[Joseph Meehan]

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
(e-mail address removed).

Thanx!
Arlene

No need. One table is fine. Just had an indicator field, like a yes no
field.