Total cost from several subreports? ------------M------------

[Mark909]

Ive got several sub reports showing the results of queries to calculate costs
of different materials.

Each of the subreports has been grouped to show the total costs at the
bottom of each one.

What I was wondering was if it is possible to take the total costs from each
subreport and add them together to give a combined cost of total costs......

Thanks for your help!

 

[Gina Whipp]

Mark909,

Yes it is possible. On the main report...

=[YourSubreport].[Report]![YourTotaledTextField]+[YourSubreport].[Report]![YourTotaledTextField]+Keep
going...


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Mark909]

Thanks Gina. Where abouts on the main report does it need to go? A Label or
Text Box? Im still a bit of an Access noobie so need a little more info.
Thanks!

Mark909,

Yes it is possible. On the main report...

=[YourSubreport].[Report]![YourTotaledTextField]+[YourSubreport].[Report]![YourTotaledTextField]+Keep
going...


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Ive got several sub reports showing the results of queries to calculate
costs
of different materials.

Each of the subreports has been grouped to show the total costs at the
bottom of each one.

What I was wondering was if it is possible to take the total costs from
each
subreport and add them together to give a combined cost of total
costs......

Thanks for your help!

 

[Mark909]

Ive figured it out now. The expression needs to go in the Control Source of a
new text box. Thanks once again for your help gina

Thanks Gina. Where abouts on the main report does it need to go? A Label or
Text Box? Im still a bit of an Access noobie so need a little more info.
Thanks!

Mark909,

Yes it is possible. On the main report...

=[YourSubreport].[Report]![YourTotaledTextField]+[YourSubreport].[Report]![YourTotaledTextField]+Keep
going...


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Ive got several sub reports showing the results of queries to calculate
costs
of different materials.

Each of the subreports has been grouped to show the total costs at the
bottom of each one.

What I was wondering was if it is possible to take the total costs from
each
subreport and add them together to give a combined cost of total
costs......

Thanks for your help!

 

[Gina Whipp]

You're welcome...

BTW, didn't see your question at 4:00 AM (my time) but glad you got it
figured out.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Ive figured it out now. The expression needs to go in the Control Source
of a
new text box. Thanks once again for your help gina

Thanks Gina. Where abouts on the main report does it need to go? A Label
or
Text Box? Im still a bit of an Access noobie so need a little more info.
Thanks!

Mark909,

Yes it is possible. On the main report...

=[YourSubreport].[Report]![YourTotaledTextField]+[YourSubreport].[Report]![YourTotaledTextField]+Keep
going...


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Ive got several sub reports showing the results of queries to
calculate
costs
of different materials.

Each of the subreports has been grouped to show the total costs at
the
bottom of each one.

What I was wondering was if it is possible to take the total costs
from
each
subreport and add them together to give a combined cost of total
costs......

Thanks for your help!