Combine 2 tables or copy records

S

SarahJ

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!
 
K

KARL DEWEY

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