Asending order problem on report

[JSRhone]

I made a query with several columns. The first is named sate. It has [Enter state:] in the critera box and sorted in ascending order. The sencond column has city which is sorted in ascending order. The third column is phone number which is sorted in ascending order.

When I create a report based on this query, I am prompted for a state which works fine but when the report is generated the city column is not in ascending order.

Any ideas.

Thanks

Joanne

 

[Rich]

Use the reports sorting and grouping options

 

[JSRhone]

Thanks Rich works fine.

Joanne

 

[GrahamSA]

Thank you.

I just couldnt find a solution in properties