Doesn't work doesn't help too much. You get an error message? No result? Wrong result?
It should work, but not if any record contains null or empty string in even just one of those fields. In those cases, you'd need to update the field to 0 (as long as it won't be used in division) or use NZ to convert the missing value to some other value.
Last edited by Micron; 01-08-2022 at 11:34 AM.
Reason: added comment
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.