turn errors in reports to zeroes

T

tonyrulesyall

I am using Access XP.

I am using a series of dlookups to pull information.
When I do not get a match, I would like to show a zero
instead of an error.

I know that Excel has if(iserror( . . . )) to do something similar.

How would I do this in Access in a textbox in a report?
 

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

Report Group Footer DLookUp 0
Access 2002 change report header text 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
A03 - count in report footer gives me #Error? 0
dlookup in texbox in report 1
Dividing by Zero in Access Reports 9
Empty date field error 10
Completely Blank Report...no title, data, etc. 3

Top