Memo field changes characters to foreign characters

[Guest]

I have several memo fields in my query with multiple tables. The strange
thing is those memo fields’ character changes to different characters time to
time and I have no clue why it does or what triggers them to change. If I do
recreate whole query it corrects itself but it just have too many fields &
tables to recreate. Thank you in advance for your help!

 

[Allen Browne]

If the memo fields look fine when you view them directly in your table, but
display wrongly in the query, you need to help Access out a little.

1. Make sure the table has a primary key.

2. Make sure the query is not aggregating on the memo field.
If this is a Totals query, choose First instead of Group By under the memo.
Also, make sure the query's Unique Values property is set to No. (You can
also do this by deleting the DISTINCT keyword in SQL View.)

 

[Guest]

Brilliant Allen. You’re absolutely right if I remove the “Group Byâ€
statement, value shows correctly. Although, I do need a "Distinctrow"
keyword, at the least I know what's causing putting the foreign characters.

Thanks Allen!