Problem Sorting by Totals Column (sum of Donations)

[nazia]

Hello-

I created a report to display Donation Totals by Donor. I would like to sort the report by the Donation totals (so as to see who our biggest donors our in a descending list.) For some reason, the list is still out of order.

I am VERY new to this, apologies if this is a dumb question.

Here is the Group, Sort, and Total detail:
1. Sort by [Total Donation], from [largest to smallest], by [entire value], with [no totals]
2. Group on [ID], from [smallest to largest], by [entire value], with [no totals]
3. Sort by {Total Donations], from [largest to smallest], by [entire value], with [no totals]

 

[vbaInet]

If you get rid of the first sort what happens?

Is Total Donation a calculated value? For example, Sum([Donation]) ?

 

[nazia]

If I remove the first sort nothing happens- the report looks exactly the same.

The total donation is a calculated value.

I ended up running a query that calculates total donations by donor and then i created reports to sort (by totals, by donor, etc.)

Is there a clean way to calculate a value in a report and then sort it by that value? I like that I can "unhide details" and see each line within the calculated value.

 

[vbaInet]

I'm guessing you're using Access 2007 or 2010?

Move the calculation to the record source of your report, i.e. in the query and perform the group on that new alias field.

 

[nazia]

Using Access 2010.

Thanks for your responses- I thought I would be able to pick up access like any other Microsoft software, but it definitely takes some time!

 

[vbaInet]

Did you manage to do what I mentioned above or still need some more information?

 

[nazia]

yep that worked well. Now with this set up, do you know how I can limit the report by date? (so i can pull a list of donors from 2011 only or 2010 only)

 

[vbaInet]

* Put Year([DateField]) in a new column in the query
* Under the criteria row of the column above, put IN (2010, 2011)
* Untick the Show box.

Amend the red bit.