This is a simple one ...

[JRA]

Hello ...

I've been racking my brain for the last half an hour and can't seem to remember how to do this. I have a report and I want to sum the numbers of a certain field. What is the code I should use on the actual report to do this. I thought it was something like: =Sum([Page Count]); however, this does not seem to be working.

Thanks in advance,
James

 

[jimmythegeek]

=Sum([FieldName])

1) The field you are summing should be either a number of currency field.

2) You have to make sure it is in a footer however, if you put it in the detail section, your sum will be the same as the field on every line.

You can create a footer for your field, or put it in the page of report footer. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?