Access 97 - Is it possible to combine tables in this many to one way?

[Swingncole]

I have set up several tables to track equipment ID's and info. The equipment will be assigned to sites. Each site will have many pieces of the same equipment (different ID number.) How can I get access to create an output of each site listing all the equipment that they have been assigned?<br>
<br>
Thanks.

 

[smedvid]

While not real efficient, the SQL UNION may provide some assistance. Provided the table structures are exactly the same. I have never layered UNION [ALL] statements more than two deep. <br>
<br>
Select "Site A" as SiteName, EQUIP_ID from Table A<br>
UNION ALL<br>
Select "Site B" as SiteName, EQUIP_ID from Table B<br>
UNION ALL<br>
.... <br>
????<br>
<br>
htwh, <br>
<br>
Steve