I am trying to write an append query that will ONLY append the last record of one table into that of another table. Every time I try this, Access wants to Append all the records. How do you force it to only append the last record?
Append only 1 record (1 Viewer)
- Thread starter txmmoore
- Start date
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 14:57
- Joined
- May 7, 2009
- Messages
- 19,232
what is the fieldname of autonumber field?
what are the field you want to insert?
dont include the autonumber in the insert.
if ID is autonumber field in your source table:
insert into Prerelease_info (targetFiel1, targetField2) Select Top 1 sourceField1, sourceField2 From Customer_Info Order By ID Desc;
what are the field you want to insert?
dont include the autonumber in the insert.
if ID is autonumber field in your source table:
insert into Prerelease_info (targetFiel1, targetField2) Select Top 1 sourceField1, sourceField2 From Customer_Info Order By ID Desc;
Still having problems. Here is my summary:
Table1 -
ID - auto number
Name - Person's name
Table2 -
ID Select - Needs to be the same as ID in Table 1
Name - Needs to be the same as Name in Table 1
Please advise how the Insert command should look.
I only want to copy the last record in Table 1 into Table 2
Thank you!
Table1 -
ID - auto number
Name - Person's name
Table2 -
ID Select - Needs to be the same as ID in Table 1
Name - Needs to be the same as Name in Table 1
Please advise how the Insert command should look.
I only want to copy the last record in Table 1 into Table 2
Thank you!
Why? Action queries are generally tools of people who don't fully understand how databases work. You shouldn't "move" data around a database. Instead you use data to identify special records.
Please explain what the difference between Table1 and Table2 is? If you could provide actual table names that would help as well. My guess is the actual solution to your real issue is the addition of a new field to Table1.
Please explain what the difference between Table1 and Table2 is? If you could provide actual table names that would help as well. My guess is the actual solution to your real issue is the addition of a new field to Table1.
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 14:57
- Joined
- May 7, 2009
- Messages
- 19,232
you use DoCmd or DBEngine(0)(0).Execute:
DoCmd.RunSQL "Insert Into Prerelease_info ([ID Select],[Name]) Select Top 1 [ID],[Name] From Customer_Info Order By [ID] Desc;"
or
DbEngine(0)(0).Execute "Insert Into Prerelease_info ([ID Select],[Name]) Select Top 1 [ID],[Name] From Customer_Info Order By [ID] Desc;"
DoCmd.RunSQL "Insert Into Prerelease_info ([ID Select],[Name]) Select Top 1 [ID],[Name] From Customer_Info Order By [ID] Desc;"
or
DbEngine(0)(0).Execute "Insert Into Prerelease_info ([ID Select],[Name]) Select Top 1 [ID],[Name] From Customer_Info Order By [ID] Desc;"