Naming a Calculated Field

[wscott]

The Control Source for a calculated field on a report is =SUM(expresson). Can you apply a name to the field (like you would in a query) and use that name in another field?



I see that there is a Name property for the object, but I have not been able to use it for additional calculations.

[RuralGuy]

How are you trying to reference the control in another control?

[wscott]

I thought I was using square brackets just like you would in a query. I ended up using the expression builder (something I rarely find useful) which created the same code that I had hand coded and it workd.

[RuralGuy]

There you go. Whatever works...works right? Is this thread ready for you to mark as Solved?

[A S MANN]

In the calculated field property > Other >Name give unique name to that field Same name can be used any time in the same report for any other calculation porpose
Hope my advice is useful to you