I am trying to read from 2 access table. Is there a function that states if id is found in table 1 , Append and add a new column in Table 2 (the main customer table), else not found set to No in table 2?
Not sure if I completely understand your request, but one way to check if an id is in one table but not in the other would be to use the 'Set minus' operator. You will then have a set with records that are not in your table, so you can use that outcome to append them.
Answers
Not sure if I completely understand your request, but one way to check if an id is in one table but not in the other would be to use the 'Set minus' operator. You will then have a set with records that are not in your table, so you can use that outcome to append them.