Hello All,
I have 2 table in access. I am trying to check if record in table 2 exist and update the status of table 1 to "Exist" or "No". There is two column UserID and name.
Below shows a sample of what I am trying to do.
Table 1:
UserID Name
123456 James
234561 Mary
789164 Leonard
897652 Mark
Table 2:
UserID Name
123456 James
789164 Leonard
My desired output:
UserID Name Status
123456 James Exist
234561 Mary No
789164 Leonard Exist
897652 Mark. No
Thank you for your help!