Whats the best way to move multiple records in a database?

[Keaner]

Hey, I'm trying to figure out the best way to move multiple records in a databse (update). Any help or snippits is greatly appreciated.

[TheIceman5]

not clear, do you want to MOVE or UPDATE??? they are 2 totally different things.

[Keaner]

I want to update one of the fields in my database (location). The way I display the fields (by location) it will look like it has moved. So basically liek this:

Chair 12345 Gander
Computer 11111 Gander
Box 11221 Gander

Right now my database is displaying everything from Gander. But I want to be able to move all three to another location aka Lewisporte.

[TheIceman5]

search the forum for the 'UPDATE' sql query command.