var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Data Mismatch on data type - Memo
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
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?