Yes your right , not enough detail. I want to produce a update report on Service tasks which details what work has been completed during the day (Text) along with some details, time stamp on update entries, user ids etc.
I don't believe I can display Text in a data area of the pivot table therefore I may need to import data in Access and compile report that way.