The holiday hangout will go online tomorrow! If there's anything in the regular subforums that you're going to want to access over the holidays, copy it now while it's still accessible.
Don't like the snow? You can make a bookmark with the following text instead of a url: javascript:snowStorm.toggleSnow(). Clicking it will toggle the snow on and off.
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.