MS Access query returning Chinese characters – possible table corruption?

by

This is a bug typically met if grouping on a memo field.

There may be several workarounds depending on your needs:

Select 
    a, Left(b, 255) As b
From 
    table1 
Group By 
    a, Left(b, 255)

Select 
    a, Mid(b, 1) As b
From 
    table1 
Group By 
    a, Mid(b, 1)

Select 
    a, First(b) As firstb
From 
    table1 
Group By 
    a

Select 
    a, DLookUp("b","table1","Id = " & [table1]![Id] & "") AS b
From 
    table1 
Group By 
    a, DLookUp("b","table1","Id = " & [table1]![Id] & "")

More Related Contents:

  1. How do i add percentage an Access query?
  2. How do you use version control with Access development?
  3. Microsoft Access condense multiple lines in a table
  4. Bang Notation and Dot Notation in VBA and MS-Access
  5. How do I make a stored procedure in MS Access?
  6. How can I get table names from an MS Access Database?
  7. Syntax error in insert into statement – what’s the error?
  8. Is there any way to create multiple insert statements in a ms-access query?
  9. Difference between Microsoft.Jet.OleDb and Microsoft.Ace.OleDb
  10. Why is my query not updateable?
  11. Microsoft Access DBEngine.OpenDatabase() breaks for Network-Paths – Error 3050
  12. MS Access LIMIT X, Y
  13. Prevent enabling of shift bypass – Access 2010
  14. Access 2007 – Left Join to a query returns #Error instead of Null
  15. Access query producing results like ROW_NUMBER() in T-SQL
  16. Pivot Query in MS Access
  17. Save password for ODBC connection to MS SQL server from MS Access 2007
  18. How to write Case Sensitive Query for MS Access?
  19. Setting up an MS-Access DB for multi-user access
  20. Access VBA: Find max number in column and add 1
  21. MS Access prepared statements
  22. ConcatRelated function in a query
  23. Access 2007 – INSERT and instant SELECT doesn’t retrieve the inserted data
  24. UrlDownloadToFile in Access 2010 – Sub or Function not Defined
  25. Null values for variables in VBA
  26. Custom row source for combo box in continuous form in Access
  27. VBA – Run Time Error 3271 using DAO object
  28. Working with multiple programmers on MS Access
  29. Trouble with InputBoxes
  30. Get Name of Current VBA Function

Leave a Comment