getting the correct info

  • Thread starter Thread starter JohnE
  • Start date Start date
J

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
 
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
 
JohnE said:
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.
Click to expand...


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.
 
Thank you both as I did change the name of the txtbox and
it worked. Sometimes the small things are the most
troublesome.
*** John
 
Back
Top