Can one calculate a result based of

[mvital]

Can one calculate a result based off another calculated control result in an Access 2000 report?

Any suggestions are greatly appreciated!

thanks in advance,

Maribel

 

[dhookom]

Yes. If you give us a little more information such as an example, we could provide more specific help.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[mvital]

Hi Duane,

Thanks for your quick response.

My report looks like this:

Product Product Product VOC Density Emissions
Type Code Name Content

C.S CL01 Aircraft 100 7.09 0.10
_________________________________________________________
Subtotal 0.10
Coating C054 CARC tan 34.6 10.1 1048.38
Coating C056 CARC tan6 33.14 10.44 25948.62
__________________________________________________________
Subtotal 26997.00

TOTAL 27067.90

I am calculating the Emissions (calculated control):
(=([productVOCcontent]*[productdensity]*[prousage])

I am calculating the subtotal Emissions (calculated
control):
=Sum([productVOCcontent]*[productdensity]*[prousage])

I am wanting then to calculate the TOTAL by adding up all the subtotals on a particular page, again another control:

Any suggestions?

I think I might have figured it out, but interested in your suggestions.

thanks so much!

Maribel

 

[dhookom]

Page totals are more difficult than group or report totals. There is a knowledgebase article at

http://support.microsoft.com/default.aspx?scid=kb;en-us;216311&Product=acc2000

that describes how to create page totals. If you want the report totals, you can use the very same control source in a text box in the report footer.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.