Printing Report in date order, not alpha order

[RNBTRAINING]

Good afternoon,

I'd like to have one of my reports print in date order and it only prints in alpha order. How can I change this?

Thanks in advance,

 

[FancyPrairie]

Is your report based on a table or query? If it's a query, then your query should look something like this:

Select * from YourTable Order By YourDateField

If it's a table you can set the reports Order By property to YourDate field and also set the Order By On property to yes (not that you can also do this with a query)