Hi,
In my project I have a formula that checks if there are not empty fields and put the result in a new column.
Then I need to put the result to an access numeric field, but it fails, I tried
"" (empty string) : this I get an error : not compatible with number data type
asnumber(""), I get a zero
char(0) puts a zero in the column, which is wrong, because we use Empty as a way to see if there is a result...
if(not isempty([Au (MS) (g/t)]), asnumber([Au (MS) (g/t)]),
if(not isempty([Au_MS_anterieur (g/t)]), asnumber([Au_MS_anterieur (g/t)]),
if(not isempty([Au_MS_D (ppm)]), asnumber([Au_MS_D (ppm)]),
if(not isempty([Hist_Au_MS (g/t)]), asnumber([Hist_Au_MS (g/t)]),
char(0)))))
Thanks.