I tried to substitute the Sum function with Avg function (=Avg([TicketWeight]
)) and the avg function works. This problem seems to be isolated to the sum
function

Jeff wrote:
Thanks for the reply.
The problem is that =Sum([TicketWeight]) in the footer (or header) returns an
error to begin with...
This should be a very simple issue but I cannot figure out why this simple
formula is failing.
When I remove the agregate function sum and set the control source to =
[TicketWeight] it returns the value of the first line of TicketWeight1 in the
subform...

Jeff

In my opinion, the easiest way is to put a hidden textbox in the footer of
the subform. Set its controlsource to =sum([ticketweight])
[quoted text clipped - 3 lines]
I will try to use the proper terminology to describe my problem...
[quoted text clipped - 9 lines]

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201006/1