I am running a query that compares table A with table B and returns records in A that are not in B.
There is a checkbox field in table A which I want to be able to check if it is returned in the unmatched records query.
Unfortunately I cannot update the checkbox field in the query because, I assume, table A does not contain a primary key.
I am unsure how to proceed.
Is it via an update query?
Thanks
There is a checkbox field in table A which I want to be able to check if it is returned in the unmatched records query.
Unfortunately I cannot update the checkbox field in the query because, I assume, table A does not contain a primary key.
I am unsure how to proceed.
Is it via an update query?
Thanks