Changing the sorted order 2

[tcsbiz]

Hi there. I am NOT an Access developer, so, be kind...

I've been tasked with changing the sort order on an Access report. The report's record source is a query. I changed the query to indicate the new sort but it isn't reflected in the report when I run it.

There is also an On Open event procedure defined but the code is commented-out.

Am I missing a step or something?

Thanks for any help you can provide.

 

[tcsbiz]

I forgot to include that I am using Access 2007 but the database was designed originally in Access 2003.

 

[PWise]

look @ sorting and grouping on view menu

 

[MajP]

To add to PWise's statement, the sorting and grouping will override the sort order in the query.

 

[tcsbiz]

To PWise & MajP. Stars to you. Thanks. I was so focused on code and the minutia I forgot to look for the obvious.

Changing the sorting via the view menu appears to have done the trick. I need to pass it by the users but it looks good to me.

Thanks much.

 

[tcsbiz]

It passed inspection.