ACCESS query result show "#ERROR',How can i replace it with 0
( in excel, it's very easy using "if(iserror(xxx),0,xxx)". in access it's hard to handel)
anyone can help me ? thanks
ACCESS query result show "#ERROR',How can i replace it with 0
( in excel, it's very easy using "if(iserror(xxx),0,xxx)". in access it's hard to handel)
anyone can help me ? thanks
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I've looked at your db, but my Chinese is non-existent. If what you are trying to do is divide by zero, then maybe an IIF statement added that says if the field holding the divisor is zero, then the result should be zero.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks