Sorting...

[michelehaytko]

Yet another question! When I run the report, it gives me the results in alphabetical order (i.e. April August, etc) instead of monthly order... Is there a way to fix this?

Thanks!
Michele

 

[KeithG]

Try below

Switch("January",1,"February",2,"March",3,"April",4,"May",5,"June",6,"July",7,"August",8,"Septemeber",9,"October",10,"November",11,"December",12)

use the above in your query and sort by this column.

 

[michelehaytko]

I'm sorry, I'm lost Where do I put "switch" and all the data?

Thanks,
Michele

 

[KeithG]

Paste it into your query as a column. Then choose to sort by this column.

 

[michelehaytko]

I'm sorry but I'm daft I think. I tired pasting it in and got the following message "This expression is typed incorrect or is too complex to be evaluated..." What am I doing wrong?

michele

 

[Krava]

Hi, Michele!

Try to add a new column into you query. Define your own name for the column and use this syntax (enter it into blank "Field" part of the column):
MonthNo: Format(Month([DateStart]);"00"),
where MonthNo is your name of the column and "DateStart" is the field name in your table containing the date to be ordered.
Then, sort this column Ascending or Descending.

Regards

Krava.