Using MS Access to Clean up Large Lists.
I can easily see how to connect MS Access to SharePoint lists.
I can easily run queries based on Date Occurred to delete items.
What I am looking for is how to get the state of the item as that is not listed in the columns of the list.
Can someone point me to where to find this state? Is it in another list? Can I link to that table to get that list of state?