T
TS
--
TS
TS
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
DevourU
Set the record source to the query name. More info always helps.
-JS
-JS
T
TS
-- 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
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
J
John Vinson
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]