#error in addition on report

[Jeff]

Hi

I'm trying to add 4 fields together representing positive pregnancy
test results by trimester along with the old field.

The addition looks like:

=Nz([PosCount])+Nz([Pos1Count])+Nz([Pos2Count])+Nz([Pos3Count])

However, it is showing as #error on the report.

Can someone explain what might be going wrong?

Thanks

jeff

 

[fredg]

Hi

I'm trying to add 4 fields together representing positive pregnancy
test results by trimester along with the old field.

The addition looks like:

=Nz([PosCount])+Nz([Pos1Count])+Nz([Pos2Count])+Nz([Pos3Count])

However, it is showing as #error on the report.

Can someone explain what might be going wrong?

Thanks

jeff

1) What is the name of this control?
Make sure the name of the control is not the same as the name of any
field used in it's control source expression.

2) If the above is OK, then where have you placed this control in the
report?
You will get #Error if you have placed it in the Page Header or Page
Footer section of the report. If that is where you have it, then ....
See Microsoft KnowledgeBase article
132017 "How to sum a column of numbers in a report by page"

 

[Jeff]

It was #1. Thanks for the help