getting the correct info

[JohnE]

I am designing a report so that the offices and clients
can use the same. It is a summary type (roll up) report
for the 5 categories. There are simple responses of
Yes/No/NA for the 5 categories. There are unbound
txtboxes to display the numbers of the Yes/No/NA
responses. In the ControlSource I am placing the
following expression:

=Sum(IIf([VoucherEnteredTimely]="Yes",1,0))

Unfortunately, I get the #Error in the txtbox. I seek the
wisdom of the newsgroup to see where my error is.
Thanks in advance for any response to this.
*** John

 

[Fons Ponsioen]

I suspect that the textbox is named the same as the
variable, probably "VoucherEnteredTimely" if so, change
the name of the textbox to naything but the name of
variables in the source and don't use any restricted
words, and things should work.
Hope this helps.
Fons

 

[Marshall Barton]

I am designing a report so that the offices and clients
can use the same. It is a summary type (roll up) report
for the 5 categories. There are simple responses of
Yes/No/NA for the 5 categories. There are unbound
txtboxes to display the numbers of the Yes/No/NA
responses. In the ControlSource I am placing the
following expression:

=Sum(IIf([VoucherEnteredTimely]="Yes",1,0))

Unfortunately, I get the #Error in the txtbox. I seek the
wisdom of the newsgroup to see where my error is.

I can't be sure based on just what you've posted, but the
most common cause of this is that the text box is named
VoucherEnteredTimely. If it is, then change its name to
something else such as txtVoucherEnteredTimely.

 

[JohnE]

Thank you both as I did change the name of the txtbox and
it worked. Sometimes the small things are the most
troublesome.
*** John