SUM (?) in Report

[an]

Hello!
In Report I have:
Textbox1 to display VolPurge1 (numeric data field);
Textbox2 to display VolPurge2 ( " " " );
and so on, to
Textbox9 to display VolPurge9 (Numeric data field too).
I need to Sum values independently fields are filled or
not.
When there are numeric data in all fields, the SUM work
fine. When only one field is null the SUM don't work.
I would like help to this problem with formulae, please.
Thanks in advance.
an

 

[George Nicholson]

Textbox1 to display NZ([VolPurge1],0)
If VolPurge1 is Null the NullToZero function will display a zero.

and/or you can use the following in your Footer:
Sum(NZ([VolPurge1],0))

 

[an]

Sorry but when run, return msg "Enter parameter value" (?).
Thanks.
an

-----Original Message-----
Textbox1 to display NZ([VolPurge1],0)
If VolPurge1 is Null the NullToZero function will display a zero.

and/or you can use the following in your Footer:
Sum(NZ([VolPurge1],0))

--
George Nicholson

Remove 'Junk' from return address.

Hello!
In Report I have:
Textbox1 to display VolPurge1 (numeric data field);
Textbox2 to display VolPurge2 ( " " " );
and so on, to
Textbox9 to display VolPurge9 (Numeric data field too).
I need to Sum values independently fields are filled or
not.
When there are numeric data in all fields, the SUM work
fine. When only one field is null the SUM don't work.
I would like help to this problem with formulae, please.
Thanks in advance.
an

.

 

[Duane Hookom]

Are you summing across fields within one record or summing one field across
multiple records?

 

[an]

Ok.
I need to sum all values in same record.

Record 1
VolPurge1 value +
ValPurge2 without value +
ValPurge3 value +
ValPurge4 without value +
.... +
ValPurge9 value

in same record (Page1).

In another Page:

Record 2
VolPurge1 withou value +
ValPurge2 value +
ValPurge3 value +
ValPurge4 without value +
.... +
ValPurge9 without value

Thanks for you reply
an

 

[an]

Ok, GN!

I changed NZ([VolPurge1],0)
to NZ([VolPurge1];0)
and work fine.

Sincerely, thanks for your help.
an

-----Original Message-----
Textbox1 to display NZ([VolPurge1],0)
If VolPurge1 is Null the NullToZero function will display a zero.

and/or you can use the following in your Footer:
Sum(NZ([VolPurge1],0))

--
George Nicholson

Remove 'Junk' from return address.

Hello!
In Report I have:
Textbox1 to display VolPurge1 (numeric data field);
Textbox2 to display VolPurge2 ( " " " );
and so on, to
Textbox9 to display VolPurge9 (Numeric data field too).
I need to Sum values independently fields are filled or
not.
When there are numeric data in all fields, the SUM work
fine. When only one field is null the SUM don't work.
I would like help to this problem with formulae, please.
Thanks in advance.
an

.

 

[Duane Hookom]

Apparently you have found the Nz() function.
Just a word of total conjecture... adding values across a record generally
suggests un-normalized data. 9 repeating columns isn't usually the best
method of storing data.

 

[an]

Thanks for your reply.
Then so, what is the best mode, please.
an

 

[Duane Hookom]

I don't know how your fields are being used so I can also guess. Here is
just one of many resources on the web for table structures
http://www.oreilly.com/catalog/accessdata3/chapter/ch04.html.

 

[an]

Thanks for your help.
an

-----Original Message-----
I don't know how your fields are being used so I can also guess. Here is
just one of many resources on the web for table structures
http://www.oreilly.com/catalog/accessdata3/chapter/ch04.ht ml.

--
Duane Hookom
MS Access MVP





.