Total not working

[skline]

Hi there
I'm working in Access 2002 - I've built a total into a form based on a filtered query- to total several regions together.
=Sum(NZ([BC EST])+NZ([AB EST])+NZ([PRAIR EST])+NZ([ONT EST])+NZ([ATLAN EST])

What is happening is that the sum field is totalling ALL of my records together for one large grand sum - instead of each indivdual record at a time - which is what I need it to do

How do I fix this? Help. ThankS!

 

[Graham Mandeno]

That's what Sum is for - to total the values in a field across the whole
recordset.

=Sum([A]) will add up all the values in the [A] field

=[A]+ will add the [A] and values for the *current record*

=Sum([A]+) will add up the combined totals of [A] and

It seems you have the third option, but you need the seceon, so lose the
"Sum" from your expression:
=NZ([BC EST])+NZ([AB EST])+NZ([PRAIR EST])+NZ([ONT EST])+NZ([ATLAN EST])

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi there,
I'm working in Access 2002 - I've built a total into a form based on a

filtered query- to total several regions together.

=Sum(NZ([BC EST])+NZ([AB EST])+NZ([PRAIR EST])+NZ([ONT EST])+NZ([ATLAN EST]))

What is happening is that the sum field is totalling ALL of my records

together for one large grand sum - instead of each indivdual record at a
time - which is what I need it to do.

 

[skline]

Thanks! It worked! I just didn't know how to change it...