Just a little bit better than a total noob in Access and very rudimentary knoledge in SQl but here goes:
I've created a Query IN ACCESS Joining 2 tables. The join Use The Facility number and Room Number in Each Table.
Facility numbers match perfectly in both table. No issues there.
Room number however do not. IN the case of "Table 2" when a room number does not match in the Room coulmn, (and this cannot be changed to match) there is a second column "Room NAme" that the numbers would match the numbers in Table 1.
My question is this, is it possible in access to create a query in which if a match is not found for the facility/room number in Table 1 to facility/room table 2 instead look for facility/roomname in table 2?