I have a report created where the page uses a query as the back end, all works well. I need to add a text box with the summed up values; however, I keep getting the #error for the result of my sum function.
I am trying to Sum up one field called SCHDQTY. On the textbox I am trying to put the total into, I have this as the control source:
=Sum([SCHDQTY])
and I get the #Error message when I go into preview view.
What am I doing wrong?
I am trying to Sum up one field called SCHDQTY. On the textbox I am trying to put the total into, I have this as the control source:
=Sum([SCHDQTY])
and I get the #Error message when I go into preview view.
What am I doing wrong?