By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

Sorting correctly a formated "yyyy mmmm" date in a query

100+
P: 176
Hello dear users and experts:

In my current project I have a cross-tab query, with a row heading column being a date. I'm intersted for it to be sorted correctly, and it is:

04/2003, 05/2003, 06/2003, 07/2003

but when I format it according to Format([Field],"yyyy mmmm") it gets sorted by months' initial letters:

April 2003, August 2003, June 2003, May 2003

Is there a way to make it correct?

Thanks.
May 13 '07 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,635
Expand|Select|Wrap|Line Numbers
  1.  
  2. GROUP BY your formatted Date Field in a Column NOT Row Heading and set the Column Headings property = "January","February","March","April","May","June","July","August",
  3. "September","October","November","December"
May 13 '07 #2

100+
P: 176
Thanks, ADezii !!! :)
May 14 '07 #3

ADezii
Expert 5K+
P: 8,635
Thanks, ADezii !!! :)
You're quite welcome.
May 14 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.