05-05-2019 7:47 PM
Hi folks,
I got a question regarding query hoping that I can get some help. I created a sq01 query where I have a calculated field which sums up 5 other fields. I set the property of this calculated field to be same as one of the fields and used it as a selection field. when I run the query by setting calculated field to be greater than 0, it gave me no result. however when I set the field that has the same property as the calculated one to be greater than 0, it gave me correct answer. what is wrong with my calculated field? is there any data format issue where I totally forgot?
06-03-2019 1:18 PM
Hi Shundong,
Try using isnull function for each UDF in your summation.
Thank you,
Aziz