Multiple table query

G

Gwynn

I want to generate a report based on a query of 2 fields from 12 identical tables. When all the tables are added to th
query, any field that has a null value will return a null report, the same thing happens when the tables are joined
Another problem I have is, when I do get a result, the return is doubled for each table I add to the query
Any suggestions would be most appreciated.
 
Top