is it possible to transfer update record to another database table ?

[ChongKit]

Hi all.

Is it possible to transfer updated record from a database table to another database table in MS access ??

Eg. A updated record from 'Student' Table , Transfer that record to the 'Attendance' Table and that record is deleted at 'Student' Table.

Which mean the record is moved from 'Student' Table to 'Attendance' Table.

[smercurio_fc · Accepted solution]

Yes.

You need to INSERT into the other table and DELETE from the original table. Both of those words in caps are T-SQL commands.

There is no "transfer" command.

[ChongKit]

Oh i see..

I will start to work on it then.

Thank alot for your help 😄