My database has multiple tables that are populated by excel sheets out of the system.
Example: Approved, Assessment, Assn_Not_Started, LESPM, PNF, Review1, Review2,Revise and Target
Each table is populated with building numbers.
What I want to do is create a query with the building number and the table it resides in.
CO0046 Approved
CO4538 LESPM
CO5774 LESPM
CO5544 PNF
Is this possible?