Connecting 3 memo-fields in query produces weird (chinese?) characters instead of field values
Posted on 2003-11-01
I just updated yesterday from Access 2000 to Access XP. Everything seemed to work fine, I´ve been working all day in the system, but now I´ve found one strange problem (don´t know if its to do with the update or just coincidence):
I have a table "Products" with the fields "name", "types" and "extrasearchvalues". All 3 fields are Memo fields.
Now in a query I have a field:
Searchfield: ([Products].[Name] & " " & [Types] & " " & [Extrasearchvalues])
the result is that "types" and "extrasearchvalues" are displayed correctly, but instead of "Products.Name" some weird (chinese?) symbols appear.
In the same query, however, I show the "Products.Name" field on its own, and it shows the right values. So there must be something wrong with the joining, but what? I need some help!