Strange characters displayed in query results

[chrisroy1972]

Hi, I have a query that is linked to a data table. The values entered in the data table are fine and display as expected. When I run the query, the results of one of the columns show Chinese like characters instead of the actual value. But, when I filter that column by choosing 'does not contain...' the actual cell contents display. I have 2 other identical queries reading from the same table and they do not display funky. Not sure what to do here. Any thoughts?

chris

 

[vbaInet]

It's most likely a Memo field. Have a look here:

http://allenbrowne.com/ser-63.html
http://allenbrowne.com/bug-18.html

 

[chrisroy1972]

Thank you for the quick reply. The second link had an easy fix...index the memo field. I did and it worked. Thanks again.

chris

 

[vbaInet]

Good to hear Chris!