Chinese symbol + L in my memo fields

  • Thread starter Thread starter Mike Rotch
  • Start date Start date
M

Mike Rotch

My database was working fine until one day someone
complained of all records from a memo field showing up as
a random Chinese symbol followed by a small "L". The
query shows the same. Surprisingly, if I take out all
criteria for the query, it looks fine, but happens again
if I re-enter it.

Any clue what has happened and how to fix?

Thanks,
Mike
 
I'm guessing that you are using a Totals query, and the memo field is one of
the fields listed as GROUP BY fields. This is caused by Jet misinterpreting
the UniCode information.

Try changing the memo field to First instead of Group By in the query's
design window.
 
Excellent! You saved me Ken!
-----Original Message-----
I'm guessing that you are using a Totals query, and the memo field is one of
the fields listed as GROUP BY fields. This is caused by Jet misinterpreting
the UniCode information.

Try changing the memo field to First instead of Group By in the query's
design window.

--

Ken Snell
<MS ACCESS MVP>




.
Click to expand...
 
Back
Top