how do i total negative and positive numbers in the same column to

[Guest]

I am trying to add a colmn of positive and negstive numbers to get the net
result. the Report is summing all cells as if they are all positive numbers

 

[Douglas J. Steele]

The only way that should be happening is if you're applying the Abs function
to the values (to convert them all to positive numbers), or if the numbers
are stored as positive numbers, with a second column indicating which are
positive and which are negative.

Is your case either of those two scenarios?

 

[Al Camp]

RIC
Try Sum(Abs(yourvalue))

 

[Guest]

Summation in the normal way should give you precisely that. Put a text box
control in a group or report footer with a ControlSource of:

=Sum([NameOfField])

Ken Sheridan
Stafford, England

 

[Joseph Meehan]

I am trying to add a colmn of positive and negstive numbers to get
the net result. the Report is summing all cells as if they are all
positive numbers

I had to read your message three times to be sure what you wanted. If I
am right and the period after the word "result" was meant to be a comma and
you intended not to capitalize the first letter of the next word, then Al
wrote the correct answer. You want to use the Abs function as he indicated.
It will work as you want.