Month Order Cross tab issue

[Noah114]

I have a crosstab query that I would like to use in a report however I am having a problem with proper date alignment. For example, how have months imported as numbers, i.e. 7 = July

The cross tab query has the months in order, 7,8,9 however when I use the monthname function I get

August July September

 

[Lilliabeth]

In the Query property sheet, in the Column Headings properties, enter the column labels in the correct order, seperated by commas.

 

[Lilliabeth]

Oops, typo: in the 'Column Headings' property, not properties.

 

[Noah114]

What happens if the months are constantly changing?

 

[Lilliabeth]

Sorry, I don't know of any other way to sort columns month-wise instead of alphabetically in a query.

Maybe some one else will have a suggestion.

 

[MajP]

Why don't you just programmatically set the captions on your labels when the report opens.

 

[dhookom]

Take a look at faq703-5466 to see if it provides a usable solution.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]