[MS_AccessPros] Re: Long text field returning Japanese script

 

James,

This happens whenever I forget and include a long text field in a Group By query. The work around is to exclude long text fields from the Group By query. Then create a new query that links the Group By query the original table and add the long text field(s) in a basic query that does not sum.

Hope this helps.

Wayne

__._,_.___

---

Posted by: kwheil@cox.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___