Dates don’t sort by month (1 Viewer)

[arage]

Hi,
What does it mean when the sort/group order of your date field in a report only gives you the option of ascending or descending, not by month say?

 

[Rich]

It means access is sorting alpha and not by date.Add Year([TbleName].[DateField])*12+DatePart("m",[TbleName].[DateField])-1 and sort by that.

 

[Pat Hartman]

If you formatted the date field in the query, remove the format command and do the formatting in the report rather than in the query.