Forum home » Delegate support and help forum » Microsoft Access Training and help » access training - Multiple sort criteria in a query
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access training - Multiple sort criteria in a query
Resolved · Low Priority · Version Standard
Reply Mon 24 Sep 2007, 14:43Delegate Paul said...
Paul has attended:
Access Intermediate course
Access Advanced course
Multiple sort criteria in a query
Hi All,
I need to sort a query by, first of all, part number then within the group in my report I want to sort by either the date due or the order number (smallest number = oldest date)
Any help?
For upcoming training course dates see: Pricing & availability
RE: Multiple sort criteria in a query
Hi Paul,
Use the SORT field in the QUERY.
In the REPORT, use the SORT AND GROUP BUTTON, next to the TOOLBOX and FIELD LIST toolbar icons.
Simply add the field you want to sort by, and the way you want to sort.
Regards
Richard
|