Report Cannot Sort on Date Field

[dizy8]

Hi All,

I have a query and the sorting is just fine. But when a make a report out of this query and sort it, it doesnt follow at all. Even when i tried to sort it in ascending or descending order. I just want to sort the field [SubDate] but as you can see in the report below, it doesnt follow. Data type of [SubDate] field is a date/time. Please help.

[June7]

Ooops, accidentally duplicated post.

[June7]

Use report Order By property or Sorting & Grouping features in design.

[Welshgasman]

Reports taken NO notice of the incoming data sort order.
Need to do as June7 advises.

[June7]

Actually, report can comply with ORDER BY in query but only for very simple reports. I just tested this in a new report and sort was applied, even on date DESCENDING. I tried same query as source for an older report which really looks just as simple and the sort isn't working.

So wouldn't rely on it, use report design features to set sorting.

[dizy8]

Hi All! Thank you very much for all your reply! problem solved!