Generate report using data from multiple queries

I have 6 queries that I want to use some data from each. Each query is based
on a table that has different types of products and each has an amount
column. I want to do a combined report in tabular format with each group of
products and their amount sub-totaled as a group and then a total for all
groups. I then want to subtract this total from a set amount which comes
from one of the queries.

It sounds to me like you have a poorly designed database structure. Why do
you have six tables with different types of products? Typically you should
have one table and include a "ProductType" field in your table.

If you decide to keep your current structure, you could create a union query
to combine data from multiple tables, then use that query as the record
source of your report.

--
Rick B



"Rob Roy CC" wrote in message
...
I have 6 queries that I want to use some data from each. Each query is
based
on a table that has different types of products and each has an amount
column. I want to do a combined report in tabular format with each group
of
products and their amount sub-totaled as a group and then a total for all
groups. I then want to subtract this total from a set amount which comes
from one of the queries.