[ms_access] Re: Relationship between several similar tables to create report

[Anne W.]

Thank you, Liveson. This worked great. It took me a little bit of time 
to figure out how to get all 8 tables because I could only find 
examples of joining 2 tables, but I finally figured out that I 
needed "UNION" SELECT before each additional table. Again, thank you 
for your help. I have been struggling with this forever!
> 
> Alternatively as the case is now you can use a Union query to combine 
data from all the 8 tables and base your report on this query.
> 
> HTH
> 
> Liveson
>