Details will not display in alphabetical order in 2016

[Edward Austin]

I have a report created using the report wizard that is basically "Name" in a concatenated lastname,firstname format ahd hours worked. The report wizard gives me the option of sorting by hours worked, but not by Name, which is what I want. I have tried adding an ORDER BY clause to the report data source. I have tried creating a sort order by the Advanced Sort tab. And neither of them work. Before joining this forum, I found lots of very out-of-date advice at other locations but I am still banging my head on the wall. Better that than on my monitor. Any help would be appreciated.

[Edward Austin]

Ok. I found the answer to my own question. In the report design view, below the report footer definition, there is sort by information. Once I found that, getting the sort order however I wanted was no problem. The Access 2016 Bible probably has that information in it somewhere, but I haven't read all one thousand pages.