Hello everyone

I have asked this question in the MS Access Forum, but was not getting any answer.

I am trying to use the PivotTable, but Access will not read some of the columns correctly due to that there is text in the field, and it is looking at it as a number.

So I wanted to know if there is another way to build dashboards, where my data will come from access 2010, and still be able to up date automatically.

Thank you in advance.
Tony