By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,264 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Chinese chars output from query??

P: n/a
A client showed me this one.

In a totals query that counts items and links to a parent record, what
should be the output from a memo field shows up as Chinese characters - I
kid not.

He has a parent record that contains some base info, date etc and a Memo
field for notes. In a related table are details of items. He wanted to count
the items for a particular header record so linked the two tables on the id
and in the query grouped on the id and a memo field from the header, and did
a count on the detail id.

The header id and item count came up fine, but the grouped on memo field
contains one Chinese character, different for each row. I swear these are
Chinese characters.

I tried to do this in another database, different tables, and get just the
familiar square character, but still none of the memo data. And yet with
different tables I get the first row of text.

I get around it by using Left and just grouping on the first 50 chars, or
splitting into 2 queries, one to do the item count that is then used in
another to retrieve the details from the header.

But does anyone have any clues as to what is going on here. Why it happens
in some cases and not others?

Jeff Pritchard
________________
Asken Research Pty. Ltd.
Access Database Developers
http://www.asken.com.au

May 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
This is a common result of doing a Group By on the memo field in the query.
Change the field to a First([NameofMemoField]), assuming that the record is
unique enough in the query's selected fields that only one memo field's
value will be possible.

--

Ken Snell
<MS ACCESS MVP>

"Jeff" <je************@asken.com.au> wrote in message
news:44***********************@per-qv1-newsreader-01.iinet.net.au...
A client showed me this one.

In a totals query that counts items and links to a parent record, what
should be the output from a memo field shows up as Chinese characters - I
kid not.

He has a parent record that contains some base info, date etc and a Memo
field for notes. In a related table are details of items. He wanted to
count the items for a particular header record so linked the two tables on
the id and in the query grouped on the id and a memo field from the
header, and did a count on the detail id.

The header id and item count came up fine, but the grouped on memo field
contains one Chinese character, different for each row. I swear these are
Chinese characters.

I tried to do this in another database, different tables, and get just the
familiar square character, but still none of the memo data. And yet with
different tables I get the first row of text.

I get around it by using Left and just grouping on the first 50 chars, or
splitting into 2 queries, one to do the item count that is then used in
another to retrieve the details from the header.

But does anyone have any clues as to what is going on here. Why it happens
in some cases and not others?

Jeff Pritchard
________________
Asken Research Pty. Ltd.
Access Database Developers
http://www.asken.com.au


May 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.