Order by Weekday

[CarlyS]

Does anyone know a trick to have reports and charts order weekdays the way the calendar does and not alphabetically?

It looks really silly to read my graph with Friday coming first.

 

[WayneRyan]

Carly,

You can use the WeekDay function to sort them properly. For a report, you
could just make the numeric field invisible ... not sure what you can do in
your graphing environment.

Wayne

 

[CarlyS]

Great-Thanks again Wayne!

 

[CarlyS]

I found the way to fix this problem on the chart as well. View the properties of the chart and click on the ... in row source. Select a sort order for the field you want to sort by in the chart's underlying query.