filter data in Access

[aristaeus]

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?

[Allen Browne]

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().

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"aristaeus" <aris...@discussions.microsoft.com> wrote in message
news:2B348341-5F76-4728...@microsoft.com...