Data type mismatch

[22strider]

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

 

[revans]

I just tried Double and it seems to convert just fine. Decimal not so much. Decimal is one of those SQL server compatibility datatypes that wasn't implemented too well.

hth,

Rich

 

[22strider]

thanks; Double works just fine.