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
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
