If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2"
Hi, I need help to enter a field entry in the MS Access 2003 > Query > Design View.
Basically, I have two tables, one has a manually entered postcode, the other table has a list of postcodes. I want the query to check the manually entered postcode against the second table with the list of postcodes, and return a 1 if the postcode exists in the lookup table, and a 2 if it does not find the postcode.
Any help much appreciated.