Hello Friends
Could you please help me get around this data type mismatch error that I am getting while executing a query?
I have a database in which one data type of one of the columns is "memo" even though it contains numbers. One of the record for example is "0.244897961616516". Now I have to set up criteria on this column for my reports (using comparison operators). And I am getting error that there is data type mismatch.
I tried converting it to "number" but that didn't work. It truncated above given number to zero (0) even after selecting field size decimal.
any ideas?
Thanks
Rajesh
Could you please help me get around this data type mismatch error that I am getting while executing a query?
I have a database in which one data type of one of the columns is "memo" even though it contains numbers. One of the record for example is "0.244897961616516". Now I have to set up criteria on this column for my reports (using comparison operators). And I am getting error that there is data type mismatch.
I tried converting it to "number" but that didn't work. It truncated above given number to zero (0) even after selecting field size decimal.
any ideas?
Thanks
Rajesh