Field does not always show up

[Aurora]

I am using Access 2003
I have a report that has two columns of numbers. Each page of the report is
for a different employee. At the end of the report I have two total fields ;
one for each column. The one total field (for column 1) shows up on each
page of the report, but the 2nd total field (for column 2) only shows up on a
couple of pages within the report (Ex page 1 and 21 out of 35 pages) . I
have never had this happen before. Can anyone give me an idea of what is
going on? What should I be looking for to correct this problem?
I would appreciate any help you can give me.

aurora

 

[KARL DEWEY]

A Null summed with a number equals a Null. Use a calculated field so that a
zero is returned if the field is null.
My_Calculated_Field: Nz([YourField], 0)

 

[Aurora]

Karl - first of all - thank you for responding.
I am not sure I understand what you are telling me. My formula (for the
problem column) is =+[field1]+[field2]+[field3]+[field4] ect. My first
column is counting years of employment and the second column is wages earned
each year. I used the same type of formula for the first column and
everything is OK. Do you have any other ideas as to what my problem is?

Aurora

A Null summed with a number equals a Null. Use a calculated field so that a
zero is returned if the field is null.
My_Calculated_Field: Nz([YourField], 0)
--
KARL DEWEY
Build a little - Test a little

I am using Access 2003
I have a report that has two columns of numbers. Each page of the report is
for a different employee. At the end of the report I have two total fields ;
one for each column. The one total field (for column 1) shows up on each
page of the report, but the 2nd total field (for column 2) only shows up on a
couple of pages within the report (Ex page 1 and 21 out of 35 pages) . I
have never had this happen before. Can anyone give me an idea of what is
going on? What should I be looking for to correct this problem?
I would appreciate any help you can give me.

aurora

 

[KARL DEWEY]

If there is a Null field in a record when you use
=+[field1]+[field2]+[field3]+[field4] ect. then the results will be Null.
To overcome this use
=Nz([field1],0)+Nz([field2],0)+Nz([field3],0)+Nz([field4],0) ect.

--
KARL DEWEY
Build a little - Test a little

Karl - first of all - thank you for responding.
I am not sure I understand what you are telling me. My formula (for the
problem column) is =+[field1]+[field2]+[field3]+[field4] ect. My first
column is counting years of employment and the second column is wages earned
each year. I used the same type of formula for the first column and
everything is OK. Do you have any other ideas as to what my problem is?

Aurora

A Null summed with a number equals a Null. Use a calculated field so that a
zero is returned if the field is null.
My_Calculated_Field: Nz([YourField], 0)
--
KARL DEWEY
Build a little - Test a little

I am using Access 2003
I have a report that has two columns of numbers. Each page of the report is
for a different employee. At the end of the report I have two total fields ;
one for each column. The one total field (for column 1) shows up on each
page of the report, but the 2nd total field (for column 2) only shows up on a
couple of pages within the report (Ex page 1 and 21 out of 35 pages) . I
have never had this happen before. Can anyone give me an idea of what is
going on? What should I be looking for to correct this problem?
I would appreciate any help you can give me.

aurora