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

 

[larryww]

That should be correct. Perhaps [Page count] is nonnumeric.

Create a small table from your current recordsource (say, TOP 10 records, and a few salient fields), and run the wizard on that to see what happens. (Confessing that too often I myself try to solve issues on the full data set and waste time!)

FWIW, I used to have the same problem in Access 2.0. The ONLY way I could get a sum was from the wizard, it seemed.

The way I addressed it then -- and you can try it now -- is by copying an existing, working sum field that's already on the report. Then, even if it was just a brain f**t, you accomplish the objective.