On Error

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have a control from a query that gives me #Error when there are no
records, I need it to be 0 if the there are no records, I tried this
but to no avail.

=Nz([NT],0)
Thanks
DS
 
what type of control? and how is it being populated?
I dont understand 'a control from a query'

Dorian.
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
cannot use nz function 5
Error Installing "ADAPTEC EZCD 4.04" 1
Invalid use of null value error Access 2007 0
NZ #ERROR 15
Flickering Error message: Check duplicates 3
DLookUP 4
Nz function not working 9

Back
Top