convert memo to numeric/double

[garry111]

I have two memo field in a table. I have to calcluate the sum of the two memo fileds. Here is my sql

Select sum (amt1+amt2) as tot from employee group by id;

I am getting error cannot have memo fields in aggregate function.

How do I convert the memo fields to numeric in sql query and caculate the sum.

Thanks.

 

[Sammy B]

The first question is why are you storing numbers in a Memo field?.. And if there is no good reason you might want to go into the tables and change its field type into 'number'. If there is a good reason you could do the following:

Select sum (Val(amt1)+Val(amt2)) as tot from employee group by id;

Hope this helps

Sam