Gavroche00
Technical User
Good day all,
Would anyone tell me why, in a report, when a text box has a control source and a name, I can sum the controlsource and not the name? If the control source in the table is called TOTAL and I give it the name txtTotal, why can't I get another unboud textbox to be =sum('txttotal') when of course =sum([total]) works.
Let me rephrase it another way, Can I ever reference a text box through its name to be used in another calculated field?
David
Would anyone tell me why, in a report, when a text box has a control source and a name, I can sum the controlsource and not the name? If the control source in the table is called TOTAL and I give it the name txtTotal, why can't I get another unboud textbox to be =sum('txttotal') when of course =sum([total]) works.
Let me rephrase it another way, Can I ever reference a text box through its name to be used in another calculated field?
David