Hi,
So I kind of solved my problems from the previous thread. only the following, probably very simple, issue left.
see the attached 3 images which display what my table looks like in access in datasheet view and pivot table view, and in excel pivot view. The Access pivot table view is perfect for what I need but when I export it to excel, see the result. I get all numbers!
How can I view this table in excel pivot exactly as it is in access pivot?
if can't view the images, links below
http://img442.imageshack.us/i/accesspivot.jpg
http://img696.imageshack.us/i/accesstable.jpg
http://img225.imageshack.us/i/excelpivot.jpg