Master Query indicating which tables are used

[Huddle]

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?

[June7]

Possibly a UNION query. Assuming each table has BuildingNo and unique ID fields, consider:

SELECT ID, BuildingNo, "Approved" FROM Approved
UNION SELECT ID, BuildingNo, "Assessment" FROM Assessment
UNION SELECT ID, BuildingNo, "AssnNotStarted" FROM Assn_Not_Started
UNION SELECT ID, BuildingNo, "LESPM" FROM LESPM
UNION SELECT ID, BuildingNo, "PNF" FROM PNF
UNION SELECT ID, BuildingNo, "Review1" FROM Review1
UNION SELECT ID, BuildingNo, "Review2" FROM Review2
UNION SELECT ID, BuildingNo, "Revise" FROM Revise
UNION SELECT ID, BuildingNo, "Target" FROM Target;

[Huddle]

It did work with a Union Query. Thanks