Chinese characters returned in Query when I add criteria

S

Singlespeed

Registered User.

Local time

Today, 06:05

Joined

Jun 5, 2009

Messages

33

• Jan 24, 2011

• #1

I have a simple query which works until I try to add a simple filter criteria, the results seem to get converted to chinese-ish characters - how do I prevent this, its a 2007 database migrated from 2003. the field causing the problem is ALN_REVIEW

 

V

vbaInet

AWF VIP

Local time

Today, 14:05

Joined

Jan 22, 2010

Messages

26,374

• Jan 24, 2011

• #2

Is this field a Memo field?

 

S

Singlespeed

Registered User.

Local time

Today, 06:05

Joined

Jun 5, 2009

Messages

33

• Jan 24, 2011

• #3

Yes it is a message field

 

S

Singlespeed

Registered User.

Local time

Today, 06:05

Joined

Jun 5, 2009

Messages

33

• Jan 24, 2011

• #4

sorry, memo field

 

V

vbaInet

AWF VIP

Local time

Today, 14:05

Joined

Jan 22, 2010

Messages

26,374

• Jan 24, 2011

• #5

You can't Group By a memo field unfortunately.

Change Group By to First.