JT8337
asked on
Access 2013 qry from a SharePoint 2013 list
I have a list in SharePoint 2013 that has a choice field that allows multiple selections. The users click checkboxes to make their selections. Some check one box, others up to ten checkboxes. In the column in the SharePoint list called "Type", the selections are divided by a comma if there is more than one selection. As an example: Choice1, Choice2, Choice3.
I can't create a View of the SharePoint list where it is grouped by Type which is a choice field. I need to create a query in Access that can show each of the Types a company is and then group the data by type. So a company may show up in several Type groups.
I can't create a View of the SharePoint list where it is grouped by Type which is a choice field. I need to create a query in Access that can show each of the Types a company is and then group the data by type. So a company may show up in several Type groups.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER