Sum wont' work

[Guest]

I have 3 colums I want to run a sum at the bottom of each report page. I
have everything in place, but it doesn't seem to be calulating the whole
column. The numbers in the sum are numbers from the column, but not the sum.
Gosh I hope this makes sense!

Can anyone help?
Thanks,
Cug

 

[Guest]

Hi

Can't really offer much advice as you don't give enough details.

Have you got a textbox in the report footer or group footer with something
like this as the source

=Sum(Nz([FieldName]))

Note - change FieldName to the real name of the control (this may be
different from the field name that the control gets it's data from. To check
the name
open the form in design view
right click the control you want to sum
look in the "other" column to chach the name

hope this helps

 

[Guest]

Thanks Wayne. I didn't have the NZ in the field. I added it and it worked.

:

Hi

Can't really offer much advice as you don't give enough details.

Have you got a textbox in the report footer or group footer with something
like this as the source

=Sum(Nz([FieldName]))

Note - change FieldName to the real name of the control (this may be
different from the field name that the control gets it's data from. To
check
the name
open the form in design view
right click the control you want to sum
look in the "other" column to chach the name

hope this helps




--
Wayne
Manchester, England.



:

I have 3 colums I want to run a sum at the bottom of each report page. I
have everything in place, but it doesn't seem to be calulating the whole
column. The numbers in the sum are numbers from the column, but not the sum.
Gosh I hope this makes sense!

Can anyone help?
Thanks,
Cug