How do you edit report sort order after query on which it's based is edited?

[creolejazz]

Hi. I've got a report based on a query. The query has its results sorted ascending in "field A". Everything worked great.

I've had to edit the query -- added a couple of fields and changed the sort order. Insteading of sorting "field A", "field B" is now sorted ascending.

I've edited the report by adding those new fields but the report is still sorting the data by field A.

How do I edit the report to have it reflect the new sort (field B)? I know I can creat a NEW report based on the edited query, but wonder if there's a way to edit the existing report so that it reflects the new sort order (field B instead of field A) in the query.

 

[Beetle]

Look at Sorting and Grouping under the View menu in report design. Field A is probably still being used there.

 

[creolejazz]

Yes, that did it. Thanks.

 

[boblarson]

Just an FYI - Sorting is done on a report by using the Sorting And Grouping instead of the query's sorting. The query's sorting does not maintain itself when used as the record source of a report.