Language Issue in Access Query

[somnath]

Hi,

I am new to MS Access and facing challange with a query, not sure how to resolve it. Will greatly appreciate if someone can help me with my issue. I have a query which looks up value from a table filed. The field in question is a memo and the data entered there is in English. When I am viewing the data in the table I am able to view the same in Englinsh, however when I am quering the table using my query it is showing me some other language (appears to be Japanese or Chinese) not sure why is this happening .

Thanks
-Som

[SoftwareMatters]

Are you using a group by in the query? If so you could try changing it to First in the total row.

Or if the text in the memo field is <= 255 characters then change it to a text data type.

Failing that you could try compacting/repairing the database.

[somnath]

Are you using a group by in the query? If so you could try changing it to First in the total row.

Or if the text in the memo field is <= 255 characters then change it to a text data type.

Failing that you could try compacting/repairing the database.

You hit the nail on the head. Let me check if First works. will keep you posted.

Thanks for your help