Sort By Date

[JBM]

I have read through several posts and still aren't sure how to do this:

I have report that is generated based on a query which is based on a date range prompt. I would like to have the report generated in an ascending date range (i.e. - M/D/Y). The date field is a "Short Date" type. The date range criteria for the query cloumn is:

Between [Forms]![Event Date Prompt]![Beginning Date] And [Forms]![Event Date Prompt]![Ending Date]

It sounds like from what I've read that I need to tag on to the end of the above code something like:

MonthDayYear([DateField])

Just not sure exactly how to code it. Any suggestions...Thanks Much!

 

[Rich]

Why cant you use the sorting/grouping option on the report?

 

[kbrooks]

That's exactly what I do...leave the query alone and within the report use the sorting/grouping options. Works slick.

 

[JBM]

Thank you for your replies. I finally found where this feature is and will give it a try. As you can gather I'm not trained in Access dev., this is my first db using it and rely heavily on the help menu and these forums when I get dev. assignments. So thank you again for your assistance.