Copy Information Within a Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access97 database that keeps track of patients in our facility
along with dietary information. The information is stored in a table with
"Room Number" as the primary key. Often patients are transferred from one
room to another. How can I copy all of the information in the table, except
room number, to another record within the table? I would also need to go
back and erase the old record, but I figure that could be done with a delete
query.
 
Kellogg said:
I have an Access97 database that keeps track of patients in our
facility along with dietary information. The information is stored
in a table with "Room Number" as the primary key. Often patients are
transferred from one room to another. How can I copy all of the
information in the table, except room number, to another record
within the table? I would also need to go back and erase the old
record, but I figure that could be done with a delete query.
Click to expand...

Why don't you just change the room number on the existing record?
 
That might work, but there is other information in the table that is related
to the room and it's physical location in the hosptial and which nursing unit
it is assigned to. The end users of this database are not real computer
literate and I need to make this as simple as possible for them.
 
Back
Top