I need some coding that will assist me in determining if data already exists in another table.

Basically, there are two free tables involved. The first table will house only one field (the account number (this is the table where data is entered by the end user)).

the second table will house data imported over a course of time and stored for record purposes.

Essentially, I need some help with finding a code that go through each individual account number in the first table (one by one) and seeks through the second table attempting to location a match. If the second table does not house an account number from the first table, that missing account number will be appended into the second table along with the current date.

However, if an account number in table one matches an account number in table two, only the date is replace with the current date for that account number.

Can anyone help me out? thanks!!!