Sort on Sub Totals of a Group in MS Access Report

[mrmmickle1]

I have data that I have put into a Report.

The Group and Sort Setup I have looks like this:

Group on Date Received > Newest to Oldest
Group On Data Entry Tech
Sort By Num Of ACCN > Largest To Smallest > This doesn't seem to work Num of ACCN is a Calculated Field which comes from two Number Fields

The Report Look Like This Now:

Excel 2012
	A	B	C	D
1	May Daily Totals
2	Date Received	Wednesday, May 20,2015
3
4	Data Entry Technician			ACCN Total
5	Tiffany			5
6	Mike			55
7	John			15
8	TOTAL			75
9	Date Received	Wednesday, May 19,2015
10
11	Data Entry Technician			ACCN Total
12	Tiffany			5
13	Mike			100
14	John			15
15	Andrew			300
16	Lanette			25
17	TOTAL			445
Sheet1

I would like for it to look like this:

Excel 2012
	A	B	C	D
1	May Daily Totals
2	Date Received	Wednesday, May 20,2015
3
4	Data Entry Technician			ACCN Total
5	Mike			55
6	John			15
7	Tiffany			5
8	TOTAL			75
9	Date Received	Wednesday, May 19,2015
10
11	Data Entry Technician			ACCN Total
12	Andrew			300
13	Mike			100
14	Lanette			25
15	John			15
16	Tiffany			5
17	TOTAL			445
Sheet1

Is there an easy way to accomplish this? It doesn't seem to work when I use the Sort. Any help would be appreciated.

 

[mrmmickle1]

Here is a link to a ScreenShot of the Design View for the report if needed: https://www.dropbox.com/s/2t6merg4nl7jsdy/MayReportExample.JPG?dl=0

Report View: https://www.dropbox.com/s/58m5km8igcf9r4a/Report View.JPG?dl=0

 

[mrmmickle1]

I was able to accomplish this task in an SQL Statement:

[COLOR=#0000ff]SELECT[/COLOR] [DS-Work-Log-May 2015].Date_Received, [DS-Work-Log-May 2015].Data_Entry_Tech, Sum([DS-Work-Log-May 2015].Num_of_ACCN) [COLOR=#0000ff]AS [/COLOR]TOTAL
[COLOR=#0000ff]FROM[/COLOR] [DS-Work-Log-May 2015]
[COLOR=#0000ff]GROUP BY[/COLOR] [DS-Work-Log-May 2015].Date_Received, [DS-Work-Log-May 2015].Data_Entry_Tech
[COLOR=#0000ff]ORDER BY[/COLOR] [DS-Work-Log-May 2015].Date_Received[COLOR=#0000ff] DESC[/COLOR] , Sum([DS-Work-Log-May 2015].Num_of_ACCN) [COLOR=#0000ff]DESC[/COLOR];

However, I am still unable to sort in the report. I think I have to sort on an expression.... However, when I try to use the context of the SQL statement (Sum([DS-Work-Log-May 2015].Num_of_ACCN) DESC) Access gives me an error message that says I am not allowed to use aggregate functions in sorts...

Any ideas of what I can do to accomplish my task??

 

[mrmmickle1]

Bump