Textbox

[sislman]

Hi,

I have a report which contains the following textboxes which contain Runningsum (all over) calculations:

[cum.earned prm] / [cum.net prm] / [% of cum.earned of cum. net]

I need to calculate [cum.earned prm] as a % of [cum.net prm] with the result appearing in [% of cum.earned of cum.net]

Im fine doing doing calculations where im using control sources but am not sure how to do do them with calculated results in Textboxes.

Please help

Regards

 

[TedMartin]

Does this help?

Make the textbox Control Source

=([FieldName1]/[FieldName2]) assuming FiledName (s) 1 and 2 are on your report - even though they may have their Visible Proprty set to False.

Try it with something simple first