Forum home » Delegate support and help forum » Microsoft Access Training and help » Creating reports from queries
|
|
|
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. |
Creating reports from queries
Resolved · Medium Priority · Version 2007
Reply Tue 15 Nov 2011, 10:15Delegate Sarah said...
Sarah has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Creating reports from queries
I have created a query to find out how many delegates are booked onto a training course. I have also created a report based onthis query with the intention of this being the register for the day.
I can't find a way of sorting the data so that it is in alphabetical order of delegate name
For upcoming training course dates see: Pricing & availability
RE: Creating reports from queries
Hi Sarah,
Thank you for your question.
Do you mean sort the results of the query or the report?
If you mean the query do the following in Design View:
1. In the third row of the grid click into the sort box under the field and choose ascending or descending.
If you mean Reports:
1. Go into Design View and click on the Group and Sorting option button on the Grouping and Totals tab. Now click Add a Sort and choose the field you wish to sort by.
I hope this answers your question.
Regards
Simon
Thu 24 Nov 2011: Automatically marked as resolved.
|