Removing Sorting And Grouping

[garyd1234]

Hi,
I had Sorting and Grouping turned on for a particular field in my report. I have since changed my mind and sort the table that the report pulls from. The report won't let me turn off the sorting and grouping on that field. I take out the field and the Ascending word from the sorting/grouping box. Then I get an error saying I must have a field to sort or group on for the report. How do I remove the sorting and grouping? Thanks

 

[Joe4]

I am not sure why you are having trouble removing, but here is a potential workaround. Is the data sorted in your Data Source (query or table)? If so, if you sort it in the same manner in the report, it won't change the order.

 

[mdmilner]

I don't know that Access does this - just something I'm guessing on.
Is there any chance that the default behavior of Access when creating a report (and sorting) is to auto_generate a SQL query as the source object for the report?

And -- could that source object still be in place?

aka

SELECT * FROM tblName ORDER by field1;

(in addition to other SORT properties)

Mike