Date order

[paul young]

I created a query to collect incidents in a ascending date order, and the date of incidents were displayed correctly. When I created a report based on that query, the date order on that report is incorrect. The dates were slightly not in order. Why is that?

 

[WayneRyan]

Paul,

They shouldn't be, but to be sure, when you have your report
in design view look up at the menu bar. A little to the
right of the middle is sorting and grouping. I don't have
Access with me, but it has like rows of "(--", You can use
this to explicitly sort by that date.

Wayne

 

[Pat Hartman]

If you have formatted the dates in the query that would explain why they are not sorting properly. ALWAYS sort on an unformatted date field UNLESS you order the date fields into year, month, day order. No other field order will sort properly when dates are formatted as text strings.