referring to calculated value elsewhere in report

[mjd3000]

I have a field with an average value, and I want to use that value to make a calculation elsewhere in my report. How can I refer to that value?

I have tried copying and pasting like this :

=Test.Value - Avg(Fields!ID_Outputs_Difference.Value)

And I have tried referring to the textbox by name :

txtAveOutputs.Value

But without any success..

 

[xlbo]

=ReportItems!txtAveOutputs.Value

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question