Crosstab Query - Add more than 1 column heading 1

[scriggs]

I have a cross tab query which shows week dates as column headings, like:

Name 30/10/06 06/11/06
-------- -------- --------
Mark 10 15
John 15 20

I need to show the week number as well as the date, how can I add that as a second column header, or similar.

Name 30/10/06 06/11/06
Week 43 44
-------- -------- --------
Mark 10 15
John 15 20

I did try making the header both fields combined (i.e. Weekdate & "(" & Weekno & ")" but then the sorting goes wrong as the field is seen as text, not dates.

Name 06/11/06 (Week 44) 30/10/06 (Week 43)
-------- ------------------ ------------------
Mark 15 10
John 20 15

Any ideas??

 

[AlexCuse]

Can you post your SQL?

A wise man once said
"The only thing normal about database guys is their tables".

 

[lespaul]

Alex, have a star for making me laugh first thing this morning! I love your signature!!

Leslie

 

[AlexCuse]

Wow, that was easy ;-)

Credit for that one has to go to CajunCenturion, I am sure you have seen him around. It makes me laugh every time I see it, so I had to share.

A wise man once said
"The only thing normal about database guys is their tables".