Why the sort order changes after adding a sum field in the report footer?

[qwang1115]

I have a table called “Allocation” with following data:
ClientID Amount
3 $50
2 $200
1 $100
I need to create a report sort by clientid Ascending, so I created a query called “q_sort_clientid”. The report’s record source=“q_sort_clientid” and the result is:
1 $100
2 $200
3 $50
But after I put a textbox, and set the control source=sum(amount) in the Report footer, the result is:
3 $50
2 $200
1 $100

$350

I am not sure why after I added the sum of amount, the sort order changed.

Thanks!

 

[WayneRyan]

q,

Do your sorting in the report itself.

Wayne

 

[qwang1115]

Thank you for the hint!

 

[WayneRyan]

qwang,

It's al;ways easier to do the final formatting/sorting in the report/form.

Glad you got it to work.

Wayne