Pivot Tables - PLease Help!

[choward]

Hi Guys,

firstly - abig thankyou to those who have helped me so far - i am sure the school will love the enhancements you guys have helped me create.

Anyway - i have a poblem with pivot tables.

Each course has allocated, and loading (number allocated, and the number who turned up) to a lesson. Also each course has a start date, and end date, a capacity and a location.

What i want to be able to do is at the top of the pivot table, where the groups are set - is to have the start date, the capacity, the end date and the location as the header.

if i add them the usual way by dragging them into the drop zones, it assumes i want to 'group' the courses by those fields - whereas all i want is to have them included in the header of each course.

Any ideas?

 

[choward]

... one thought i've just ahd is that in the query i use to cource the data for the pivot table - i can add a field in SQL as something like "Title: [START] + #newline# + [END] + #newline# + [CAPACITY]"

but... i do not know how to say 'new line' or even if the pivot table view will accept it.

 

[choward]

... okay... i think newline is chr(10)... but the pivot table wont actually go to a new line.... hmmm...

 

[gemma-the-husky]

newline is chr(13) AND chr(10) - carriage return and linefeed

just use the vba constant vbcrlf

so title: [start] & vbcrlf & [end] & vbcrlf & [capacity] should work