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

Posts

Sign In or Register to comment.