You are welcome, Anne Good day
Liveson ----- Original Message ----- From: Anne W. To: [email protected] Sent: Thursday, 06 March, 2008 8:21 PM Subject: [ms_access] Re: Relationship between several similar tables to create report 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 > [Non-text portions of this message have been removed]
