How do I insert the results of a calculated query in a report?

  • Thread starter Thread starter Guest
  • Start date Start date
-- I have set up a query that sums the total of each of two types of products
that need to be manufactured in the next two years. I have also created a
report that gives the total material required for all products. There is one
component in the material required which is different depending on which
product is being manufactured. I would like to insert the results of the
calculated query that I have done in the report so that I could see the
following at the bottom of my material report:

Total material component A 1000
Total Material Component A1 250
Total Material Component A2 750
 
I would like to insert the results of the
calculated query that I have done in the report so that I could see the
following at the bottom of my material report:

Total material component A 1000
Total Material Component A1 250
Total Material Component A2 750

Consider using a Subreport, if the main report and this data come from
different queries.

John W. Vinson[MVP]
 

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

Back
Top