Generate report using data from multiple queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove certain group record from report 1
Subtotals, not re-initializing 2
Access Sorting and grouping using multiple tables 0
Access Query problem 1
Access Report on Parameter Query 3
report based on select query 1
Group Totals and Grand Totals on each page 3
Calculating totals in a report in Access 2007 1

Back
Top