If you are saying that you want any record from table 1 to appear in table 2 (i.e. if there are 4 of what look like identical records in 1 you want them in 2 anyway) then if your tables really look like what you've shown, I believe that your design is the problem. There is no unique field in 1 that you could copy over to 2 as a foreign key, thereby allowing a query to append to 2.
Regretfully, I've read your posts more than once and can't really decipher what you're trying to do. If I've stated it correctly, then I have to wonder why you would want to do that anyway. It indicates there are bigger problems if data entry is failing. If on the other hand, you only want one record from 1 regardless of the number of identical records, plus one record from 2, then in the Totals query ("summary" from post 2) you would use the TOP 1 predicate - if there are other fields in 2 that you also need. If the fields are the same, then a UNION query should work. I would not try to add a sequential numbering field and make that work.
Maybe you should step back and explain what the business problem is (e.g "I have source data and I'm trying to ensure table 2 has all of it") rather than what doesn't work. We seem to know more about what hasn't worked to solve a problem as opposed to knowing what the problem is.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.