So I have two tables with a field called customer code, this can have the same value duplicated a number of times e.g "CUSTOMER1" can be in 6 rows.
I want then to check all values of this in table1 to see if they appear in table2 and return preferably a list of customer codes with TRUE or FALSE next to them to show if they appear in table2.
I can't work it out, I've also tried running a query to show the values as unique values only recently and this just ran and never finished, I had to force close access during it, do I need more RAM?
Cheers peeps,
I want then to check all values of this in table1 to see if they appear in table2 and return preferably a list of customer codes with TRUE or FALSE next to them to show if they appear in table2.
I can't work it out, I've also tried running a query to show the values as unique values only recently and this just ran and never finished, I had to force close access during it, do I need more RAM?
Cheers peeps,