Combining summary queries

[tomdee]

I want to create a form filled with summary statistics from various table within my database. The statistics are all counts and sums. For me to do this do I need to create a seperate query for each SUM fromeach table then combine them all using another query or is it possible to SUM and COUNT several fields from several different tables in one single query?

 

[aleb]

You can use a union query first and then query with agregated functions.