I am trying to create a field in my report where it displays the sum of an entire column. I tried to use the =Sum([Field]) function, but it is displaying an error in my report.
I am trying to create a field in my report where it displays the sum of an entire column. I tried to use the =Sum([Field]) function, but it is displaying an error in my report.
I presume you used the actual name of the field, which is not [Field]?
What section did you put the textbox in?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
That image doesn't show error.
If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.