I know this is really simple, but I'm having a major mental block.
I have a calculated, unbound text field with the following control source in the Detail section of a report. The field name is "txtUSD_urgl"
I am trying to Sum that field in the Footer section, but I keep getting an Input Box for the above field when I run the report--like it is looking for a parameter. The Sum field's control source is =Sum([txtUSD_urgl]).
I'm not sure why it is, but it won't let you sum a field in the detail section from the footer.
What works for me is to put a textbox in the DETAIL section with a control source of =Sum([txtUSD_urgl]) and set its Visible property to false. Then refer to that textbox from the textbox in the footer.