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?
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.