Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Move a record from one table to another

Status
Not open for further replies.
DavidC271

DavidC271

Technical User
Jul 30, 2002
17
US
I need help in moving one record (split across two tables) from its original table to a different table. I have an inventory database that has our asset information split into two tables, Device_Main and Device_Detail. The Asset number links them both, and is the PK in both tables.
I want to move the record from the active inventory tables to surplus tables.
I have tried an append query with both tables trying to update the two other tables but it failed. Will this require two queries?

Thanks for any assistance you may have,
DC
 
Sort by date Sort by votes
Yes. You can only have one destination table for any one Append query.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
611
Andrzejek
Andrzejek
BugZap13
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
306
mikrom
mikrom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
3K
lameid
lameid
combo
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
268
combo
combo
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
333
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top