My first thought is that you are using the Format( ) function, which
generates a STRING value. If you want the months as row headers, then you
can sort by a date or use the Year( ) and Month( ) functions to sort your
data.
If, on the other hand, you are using a crosstab query, and have used the
Format function to group your dates by month, then it will automatically sort
the coumn headers alphabetically unless you force it to do it in some other
order. The correct way to do this is to enter the values in the queries
property sheet in the Column Headings property. This will change the last
line of the SQL query to look something like:
PIVOT Format(DateField,"mmm") In ("Jan","Feb", "Mar", ..., "Dec");
--
HTH
Dale
Don''t forget to rate the post if it was helpful!
email address is invalid
Please reply to newsgroup only.
