Sorting Report by Day

S

Sky Warren

Hello All,

My report uses a query with the DatePart function that sorts by day of week.
The report does not obey the sort order sent by the query. I would like to
sort my report by the day of week in ascending order such as:

1/1/1990
1/1/1991
1/2/1990
1/2/1994
1/3/1990
1/3/1993

Is there a way to do this?
 
D

Duane Hookom

Use the Sorting and Grouping dialog in the report design to specify your
sort order. The query sort order is mostly ignored. Try use
=WeekDay([DateField])
 
Top