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