I’ve had problems with subtotals in forms in the past but always have been able to resolve them by going over syntax with a fine-toothed comb and finding an error on my part. In this case I have done that for hours and cannot figure out what I am doing wrong. Here is the scenario:
Access 2013 linking to MS SqlServer database view.
Field is ‘CalculatedValue’, placed in a text box ‘PrintTime’ . The field displays the correct values one each row.
!['CalculatedValue' displaying on each row]()
In a text box on the form footer, I use the control source =sum([CalculatedValue]) and get #Error
![#Error &*$^@!]()
.
I can replace that control source with =[CalculatedValue] and get the value of whichever row is active. But as soon as I edit the controlsource to =Sum([CalculatedValue]), the #Error returns.
![total box displays 'Calculated Value' correctly...]()
What am I doing wrong?
(NB: I upgraded to 2013 today just to see if it would resolve this issue or at least have better error description to help...)
Try summing the expression that defines the calculated field instead.