Re: type conversion fail, need help!!
I have a table with 4 columns: yr1(type:text), yr2(text), yr3(text), avg(number); I tried to calculate the value of "avg" by using the following query:
UPDATE tbl_test SET avg = Val((yr1 + yr2 + yr3)/3);
The Access database couldn't update all the records. Does anyone tell me why I failed? Thanks so much!