basics

[cochise]

I have 3 database with 100s of records. Each database is related by invoice number. Each record has the following fields: invoice #, date, a department, a sales class, source of call, an amount, and an employee number associated with it. This is probably easy but I want to create a report that talies the count,$ total, and % of total for each of the above fields. I've been trying to use Access help, but have yet to find any useful help. Could someone lead me in the right direction or tell me what I'm missing?

Here is an example of the information needed for one field.

Department Summary

TotalCalls Sales % of Total Sales
City1 10 $500 33%
City2 8 $500 33%
City3 2 $500 33%

Thanks for any help.

 

[JerryDennison]

This is actually fairly easy.

First, are you sure the tables are in 3 separate databases? If so, you need to either create another db and link those tables or take one of the existing ones and link the other tables to it.
Second, depending on how the records are distributed in the tables you'll need to create a union query to combine all the separate data into a single recordset. Then, using this query, create two more. One for the grand total and one using the first query and the grand total query to give you your totals by city and their percentage of the overall total sales.

 

[cochise]

I still am getting stuck. Here is where I am now. I have a union query that joins all the tables together. I can't figure out how to do the grand total query. Do I use Dsum?