Question for the group, I haven't tried this before -
I have 5 tables, one for each type of audit we do. Each has entries by location how much we audited and how many errors we found.
I would like to create 1 query that adds up the total numbers audited for all 5 areas along with total errors for all 5 areas, and group by location. The common factor on all tables is the location, it is a 4 digit number that is the same in all 4 tables for the 11 locations.
If I create a query and add the 5 tables and link the locations, the results get pretty bizarre. Any suggestions?