I have a an access DB that lisst 8 different columns of data, the header and and column value are the same, it's from a an online survey and the participants are suppossed to select one value given for a question. So there are lots of NULLs what i need is the pie chart to count all the non-NULLs and the display the count or percentage. Sound easy but dosn't seem to be. I've tried it a bunch of ways and it's not working. And chart will only work on 6 columns? I know there is a way to do it I've seen it done before but I can't seem to figure it out. Any thoughts?
Last edited:
