Good morning
One of the calculated field of my query is like this: (field1 + field2) / field3. Sometimes the value of all these fields (or only field3) were enterd value of Zeros, when this happens, the query output will display "#Error".
I get rid of that error by using the IIf(field3 = 0,0,( (field1 + field2) / field3). I am wondering if this is an appropriate solution or there are better ways to do it.
Phucon
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar