Hey guys,
I've got an aset register that keeps track of many different types of data, one such data type is staff member, represented by their initials. Occasionally (especially lately) staff members will leave, new ones wll take over and need to have the asset register corrected for this change. Originally this was done in excel, so changing the tab name was enough. I've now put all the data into access and wish to set up the following:
A prompt will come up for the current staff member to reassign stuff to: JS
A prompt will also come up for the new staff member: SS
All the data/assets that are currently assigned to JS will then be changed to SS...
How do I set the query up to do this? I tried an update, but couldn't get it to select fields where the User ID = XY, any help?
I've got an aset register that keeps track of many different types of data, one such data type is staff member, represented by their initials. Occasionally (especially lately) staff members will leave, new ones wll take over and need to have the asset register corrected for this change. Originally this was done in excel, so changing the tab name was enough. I've now put all the data into access and wish to set up the following:
A prompt will come up for the current staff member to reassign stuff to: JS
A prompt will also come up for the new staff member: SS
All the data/assets that are currently assigned to JS will then be changed to SS...
How do I set the query up to do this? I tried an update, but couldn't get it to select fields where the User ID = XY, any help?
