Update Query Help (1 Viewer)

Skupe

New member
Local time
Today, 08:30
Joined
Feb 9, 2021
Messages
6
I have a table with computers and their users. When the computer breaks I need to swap it for a working one.

I use a barcode label as the key for my computers table.

When swapping out the computer I just want to delete about 4 fields of User information on the broken machine’s record and then add that information to the replacement computer’s record.

I would think an Update Query that could copy the fields to the new machine and delete them from the old machine would be the best way to do this but unfortunately I don’t really see many examples to exchange information between records in the same table.

While just changing 1 record sounds trivial this happens anywhere from 10 - 30 times a day so automating the swap would be helpful.

Maybe better to use SQL?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 21:30
Joined
May 7, 2009
Messages
19,169
just "add" new record, and put on the pertinent information (plus a date on date field).
therefore, you have "history" of what was done.
the "latest" date is the current info for that "table".
 

Users who are viewing this thread

Top Bottom