I am newer to access and I need to create a query.
In Table A I have an ID number and two fields that have 2 character codes.
ID Code A CodeB 1234A AX B1 2345B B1 3456A C5 AX 4567A ZZ QT
In Table B I have a List of Codes as a Key.
Code Key AX B3 ZZ
I need to reference the two fields of codes against the key and display only the ID # that have those codes in either field.
Results
ID 1234A 3456A 4567A
Any help given would be appreciated.