Report not sorting by date

[PATRICKPBME]

The query upon which my report is bases has the date sorted by "ascending". For some reason, the report I run has 2 or 3 dates that are not in order. Some reports, run off the same query, are fine. I know I am missing something...

[aytee111]

You need to set the sort order in the report - go to the Grouping and Sorting icon.

[PATRICKPBME]

Sounds good and at the risk of sounding like a real novice, where do I find that?

[Bulzie]

In design of the report, right click anywhere and select Sorting and Grouping. Only other thing to check is that field in the table actually a "date" type and not text? If text it won't sort right unless you convert it to date type maybe in query(think is is DateValue function).

[aytee111]

Under the Design menu, Group & Sort.

[PATRICKPBME]

That did it. Thanks so much!!