Crosstab column headings???? Date format problem

[stickers]

Hi,

I have a crosstab query for which the column headings are dates pulled from a table. They are formatted as 27-May-2003. However, when I open the crosstab, the column heads are formatted as 27/05/03. Is it possible to format them the way I want?

Thanks,

Sarah

 

[MichaelRed]

Yes, but it necessitates extra work. Create a NEW query which pulls the dates from the original recordsource. In the New query include the date field twice. Once formatted as 'dd/mm/yy" and again as "dd-mmm-yyyy" alias them as desired. Use the first for the piviot, but the second for the col headings.

It is a bit tricky to get each in the 'right place'.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[stickers]

Hi Michael,

Thanks for the help - that sounds like it will work - how do I use the two fields separately for the pivot and column headings? The query grid won't let me. I presume you have to use SQL, but my knowledge is pretty basic - what would the syntax look like?

Sarah