Hello,
i have a Lotus notes DB from which i'am uploading data to access. Now i need to count average words in 2 fields.

I try to use this query

SELECT Avg(Len([KUComment])-Len(Replace([KUComment]," ",""))) AS LenKUC,
Avg(Len([Information])-Len(Replace([Information]," ",""))) AS LenInfo
FROM Alten_1;

but i get allways data type mismatch error 3464.

I tried the query on another 2 fields (data type Memo) and it worked. I do not have any idea why it is not working for these 2.
Probably some special characters or somethong like that.

is there another solution for counting words or can someone advise me?
thanks