filter data in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query which uses grouping of data.
When I do a filter on the results of my query my text field (Stock
Description) suddenly becomes hieroglyphics (Chinese Characters). Has anybody
any ideas?
 
This can happen if Access fails to understand the data type correctly.

Make sure that every table in this query has a primary key.

If the Description is a Memo field, in the Group By row in query design,
choose First instead of Group By under this field.

If necessary, explicitly typecast the field with Str().
 
Back
Top