I need help on a topic in Access. I have an existing table with people’s information. Then I have another table of people’s information which is not up to date. For every person in the old table, I would like to check the name in the new table and if present overwrite the fields of the corresponding record in the the old table. I would appreciate it if you could give me an idea. Thanks a lot!