Combine 2 tables or copy records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables with the exact same fields. The second table has new users
that I am trying to get on the first table without having to enter them one
at a time. I am an access newb so I am not sure how to go about getting the
records from Table 2 to Table 1 quickly. Any help would be appreciated. :)
Thanks!
 
Create a query using table2 and then change it to an Append query. In design
view of the query move cursor to the icon that looks like two datasheets with
a down arrowhead on the right. A hint 'Query Type' will be displayed when
the cursor moves over it. Select Update and then select table1 to append to.
 
Back
Top