Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Geting Chines caracters in query only if the table is in a relatonship

Status
Not open for further replies.
jben2u

jben2u

IS-IT--Management
Sep 1, 2004
6
CA
its a memo feild it was text and as soon as i changed it i got chinees caracters.
 
Sort by date Sort by votes
sounds like it is corrupted. you probably need to reenter the data. if that doesn't work you will need to delete the effected records.
 
Upvote 0 Downvote
I dont think that its corrupted I can see de data just fine when i put the table and the feeld in a query.

as soon as I put criterias in other feelds I get chinees caracters only in the memo feeld. and for your information the query has the "group by" on almost all the feelds even on the memo feeld.

thanks for your help...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
424
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
348
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
273
Moss100
Moss100
feipezi
  • Locked
  • Question
How to get the macros back as they vanish somehow in a AccessDB?
Replies
8
Views
299
combo
combo
ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
323
ziffer68
ziffer68

Part and Inventory Search

Sponsor

Back
Top