As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread:

Replace #Error with 0 in Query : MS-Access

tallgeezetallgeeze Registered User regular
edited March 2011 in Help / Advice Forum
Hello good H/A folks!

The title says it all. Due to the nature of the data combined with the math I have going on in the query I'm going to have a lot of "#Error" entries for my percentages.

I'm just looking for a way to replce those entries with a 0 if at all possible. It would make the resulting reports neater to look at for my end users.

I tried my hand at google, but the only legit result required me to sign up for stuff, which I don't want to do.

Thanks in advance!

tallgeeze on


Sign In or Register to comment.