title: Creating a Report with Access and SharePoint list
body: <p>Linked SharePoint List table into Microsoft Access. One of my columns within the SharePoint list is "Person or Group" It is a lookup that has several attributes from SharePoint users. Those attributes include ID, Name, e-mail address. I use the e-mail address attribute for workflows within SharePoint. Now I want to create a report from the SharePoint List that print out all of the names that are assigned to each record/row. Instead of printing out the name it returns the ID number. How do I get the access report to return the name that is linked from the sharepoint list?</p>