How do I Fix or Remove #Error on Access textbox?

Question

Here are what I write in the textbox control source box under property sheet.

=DSum("[CountReminder]","[QRunningReminder]")

My question is, how do I Remove the #Error on the textbox when there's no value/item in query for it to calculate? I would like or it to simply say "0" or "None". Or at least leave it blank.

Answer 1

Hi. Probably not the best way, but you could try something like:

=IIf(DCount("*","QRunningReminder")=0,"None",DSum("CountReminder","QRunningReminder"))

Hope that helps...

Answer 2

Sorry, my bad. I wrote the wrong Query name. Access automatically leave it blank if there's no data to show.