Sum text boxes using the name of the control in Access
This seems like a very basic question but I can't get it to work. I have many totals on a report. Most totals are already sums of other subtotals. I can sum easily by using the actual field names, but since the field names are long, I wanted to just name the text boxes 1- 30, or even leave them text1, text 2, text3, etc.
I can get the subtotals using =Sum([FieldName1] + [FieldName2]) and =Sum([FieldName3] + [FieldName4]) . But now I want to add all of them together and the expression will be very long. I want to do something like =Sum([text1] + [text2]) but Access keeps asking for the parameter values Text1 and Text2.