As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options
Replace #Error with 0 in Query : MS-Access
tallgeeze
Registered User regular
Registered User regular
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!
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
0
Posts
http://office.microsoft.com/en-us/access-help/iserror-function-HA001228865.aspx
So you can use an if statement to check if the value is an error, and return 0 if it is.