A query may return corrupted data for Memo fields when you run the query against a list in Windows SharePoint Services 3.0 in Access 2007

You run an advanced query against a list in Windows SharePoint Services 3.0 from Microsoft Office Access 2007. When you do this, the query may return corrupted data for Memo fields.

This problem occurs when you use the GROUP BY clause on the Memo field.

To work around this problem, change the Memo field to a Text field.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

For more information about Access 2007, visit the following Microsoft Web site: