I've been reporting with Access from SharePoint lists with no issues until today.
On List is behaving rather strangely.
The list has choice, text, date and number columns..
If I open the list with access or try to create an access view the table shows up just fine, just like my list.
If I try to create a pivot chart however when I use the field chooser to pick certain columns.. rather than I see a few items in each column I get one massive column called (Blank) i.e. it's not picking up all the data. #
E.g. Column 1 say was colours it has 4 items of blue, 15 of red and 7 of green.... instead of a column for each of these in my pivot chart I get 4+15+7.....I get one colum with 26 (Blanks) on it. :(
Any ideas why the data from the table is not showing up correctly.:(
