strange characters é¨I

A

Abrm

In a qeury with different tables. I get a memo field from one of the tables. The memo field displays "é¨I" while in the tables there is text or no value
When I remove 2 of the linked tables, the "é¨I" is gone and the results are the same as the tables

What can cause this problem
What is the solution

Abrm
 
K

Ken Snell

If your query is a "totals" query, and you're trying to use Group By on the
memo field, these characters can result when ACCESS improperly interprets
the unicode values. Change Group By to First for the memo field.

--
Ken Snell
<MS ACCESS MVP>

Abrm said:
In a qeury with different tables. I get a memo field from one of the
Click to expand...
tables. The memo field displays "?I" while in the tables there is text or no
value.
 
Top