Query Multiple Tables

[Tomfernandez1]

Hello -



I need to to query multiple Tables - each having the same structure - so here is some background that I hope provides a better understanding of my situation.

First off - I acknowledge that having multiple Tables with the same structure is not good database design. The Tables were built many years ago, when my knowledge of Access was very limited.

I have three Tables, each named by month (Jan;Feb;Mar). Each Table has 20 fields which include: First_Name; Last_Name; Van_#; Month; etc.
The same persons (First_Name; Last_Name) have participated in the same van or different vans during the three-month time period.

I believe I have to use a Union Query to combine information from the three Tables. I have accomplished this, but where I'm stuck is in trying to figure out how to report, for example: Bill Smith rode in van 334 in January and February, but rode in van 552 in March. How do I design a query to show this result?

Your advice and attention to this email is very much appreciated!

- Tommy

[TheShabz]

Just how much data do you have in the tables. I'd really recommend normalizing your database first before you continue. You'll run into many problems like this should you not. In a normalized database, this is an easy query. However, with the structure you have, things are becoming more difficult than they should be. What are the 20 fields that you have in your tables? Post those and let's see if we cant normalize your db.