I have a report which has "Sorting and Grouping" on a PC SN#.
I want the reports SORTED by a numeric field I created called Sort_Order (not by the PC SN# field).
Access appears to default to sorting on the same field I'm Grouping by.
How can I "override" this to instead sort by my Sort_Order field?

Go into sorting and grouping and put in your sorting first and then put the group in. If you used the wizard to create the report it won't let you do that, but you can go change it later.

If you have any group headers, be sure to select HAS HEADER or HAS FOOTER when you do change the group and move the controls to the new area that opens up when you add them in. Then, go to your sort field and change any group header (or footer) to NO in the Sorting and Grouping dialog.

It worked! I can't thank you enough

http://downloads.btabdevelopment.com/AWF/GladWeCouldHelp.png