A sorting issue (1 Viewer)

[lightray]

Hi, I have a report I produce for renewals. I would like to be able to change the way the output is sorted. Currently I enter a date range for when I want the renewals, this then becomes the top sort order for the output. I.E. letters are outputted by date range. I would now like to be able to sort the output by a region field in the query and still keep the date range. However I can't seem to get the desired result. Wondering what's the best way to tackle this, two queries then the report?
All help appreciated.

 

[Rich]

Use the Sorting/Grouping toolbar on the Report

 

[lightray]

Hi Rich,
Once the reports (labels & letters) are produced they are in preview mode and no sorting/gouping toolbar is present. I tried to activate one through tollbars but it doesn't give any filter buttons. ....OR are you suggesting something in design mode?

 

[Rich]

In design mode the toolbar is available

 

[lightray]

Thanks Rich, I don't why I wasn't able to figure that all out. I think I was concentrating too much on the queries. Adding the address lines in reverse order has sorted it correctly. Many thanks