Memo field turns to gibberish

M

MrDangerous

I have a query based on a table of work order information which includes two
memo fields, COMPLAINT and SERVICE PERFORMED. After I replicated the
database, the query returns what appear to be Japanese characters or squares
with punctuation marks instead of the text in the table's fields. What's the
deal?
 
M

MrDangerous

Only the data in those two fields, and only in the query results. The source
table is fine.
 
J

John Vinson

I have a query based on a table of work order information which includes two
memo fields, COMPLAINT and SERVICE PERFORMED. After I replicated the
database, the query returns what appear to be Japanese characters or squares
with punctuation marks instead of the text in the table's fields. What's the
deal?
Click to expand...

Please post the SQL of the query. You say downthread that the table
data is fine but the query is farkled - that tells us where to look
anyway, though it's a wierd phenomenon!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
M

MrDangerous

And it only happened after I replicated the database. Before that, it was
fine. I'll try to get the SQL tomorrow.
 
Top