Jay Krishna Reddy

Jay Krishna Reddy

  • 28
  • 40.5k
  • 3.1m

Access - compare two tables and update or insert data in first table

Oct 8 2020 5:43 AM

Table 1:

  1. PersNum       Name    Surname  
  2.     2321    Lenora  Springer  
  3.     2320    Donya   Gugino  
  4.     3326    Leland  Wittmer  
  5.     4588    Elmer   Mcdill  
Table 2:
  1. PersNum       Name    Surname  
  2.     2321    Lenora  Farney  
  3.     2320    Donya   Willimas  
  4.     3326    Leland  Wittmer  
  5.     4588    Maya    Mcdill  
  6.     7785    Yolanda Southall  
  7.     1477    Hailey  Pinner   
 
I need to find a way to check the personal number (field "PersNum"), and then if PersNum exists, update Name and Surname in Table1. If PersNum doesn't exist, insert new row in Table1.
 
Thanks in Advance!

Answers (6)