#error in addition on report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 24 May 2008 15:15 GMT

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

Reply to this Message

fredg - 24 May 2008 18:03 GMT

> Hi
>
[quoted text clipped - 12 lines]
>
> 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"

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Jeff - 24 May 2008 21:03 GMT

It was #1. Thanks for the help

Reply to this Message