I am trying to display a value from a query but I get "error #" appear instead. The value is a countof from a query. Any idea? Tried converting it to a string and i then get Error 0
Thanks
I suspect the calculated textbox is named the same as a
data element in the underlying query. When you use a
calculation (any time you type "= " in the text box you
must make sure that the textbox is not named the same as a
data element in the underlying table or query.
Now, when you rename the textbox make sure that your
original formula has not been updated also.
Hope this helps.
Fons
-----Original Message-----
I am trying to display a value from a query but I
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
