Totals Query from Multiple Tables

[Darock]

I have 5 tables in my database each with a donation amount field. The
ultimate goal is to make a report that displays the total seperately from
each of the tables (based on a date range).
For example, Donation Amount in Table 1 for all donations between 01/01/05
and the same for all 4 other tables.

Any easy way to do this? If i try the totals query it only accepts the date
parameter for one date column. I have made 5 seperate sum queries that work
properly but i dont know how to get them all into the same report.

Any help is much appreciated.

Thanks

 

[John Vinson]

I have 5 tables in my database each with a donation amount field. The
ultimate goal is to make a report that displays the total seperately from
each of the tables (based on a date range).
For example, Donation Amount in Table 1 for all donations between 01/01/05
and the same for all 4 other tables.

Sounds like a flawed design. Why five similar tables for similar types
of data?

Any easy way to do this? If i try the totals query it only accepts the date
parameter for one date column. I have made 5 seperate sum queries that work
properly but i dont know how to get them all into the same report.

You may need to join your main table to ALL FIVE of the Sum queries,
so you can pick up the five sums, and base the Report on this query.
You'll probably need to change the join type by selecting the Join
line in query design view; choose the option "Show all records from
<main table> and matching records from <the totals query>".

John W. Vinson[MVP]