Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!

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.