Sorting Report by Day

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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])
 
Back
Top