Good Day!
I was wondering if someone could assist me in a query to swap data in the same table.
Basically I have one table "Inv1" that houses records of floor information and computer information.
So lets say I have a record to where its serial number is 12345 and it is in column "Serial#" located on the 4th floor; now I have another record in the same table that its serial number is 987662 and it is located on the 5th floor. What I need the query to do is when your on the form looking at one of those records you click a button on the form it prompts you for the computer you want to swap it with and it will take the serial numbers from each record and swap it automatically but not touching any of the other information.
Example Before clicking button:
Serial# Floor Name Sup
----------------------------------
12345 4th John Shelli
987662 5th Dawn Joe
Example After button click and query ran:
Serial# Floor Name Sup
----------------------------------
987662 4th John Shelli
12345 5th Dawn Joe
I have tried building it with a query and a query that makes a table but I am not able to get anything to work.
Can someone please tell me if there is a way of doing this, I have racked my brain on this for a few days.
Thanks in advance!
I was wondering if someone could assist me in a query to swap data in the same table.
Basically I have one table "Inv1" that houses records of floor information and computer information.
So lets say I have a record to where its serial number is 12345 and it is in column "Serial#" located on the 4th floor; now I have another record in the same table that its serial number is 987662 and it is located on the 5th floor. What I need the query to do is when your on the form looking at one of those records you click a button on the form it prompts you for the computer you want to swap it with and it will take the serial numbers from each record and swap it automatically but not touching any of the other information.
Example Before clicking button:
Serial# Floor Name Sup
----------------------------------
12345 4th John Shelli
987662 5th Dawn Joe
Example After button click and query ran:
Serial# Floor Name Sup
----------------------------------
987662 4th John Shelli
12345 5th Dawn Joe
I have tried building it with a query and a query that makes a table but I am not able to get anything to work.
Can someone please tell me if there is a way of doing this, I have racked my brain on this for a few days.
Thanks in advance!