Total not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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

skline said:
Hi there,
I'm working in Access 2002 - I've built a total into a form based on a
Click to expand...
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
Click to expand...
together for one large grand sum - instead of each indivdual record at a
time - which is what I need it to do.
 
Back
Top