report ordered by sum?

[emanuele]

Hi everybody!
I know that it is good rule not to have sums in a tbl, but How do I do then when I want a report to be ordered by a sum lbl on a form?

In my case I have already two tbls: (tblmembers and tblpoints) and a form with a lbl that tells me how many points every member has :

=OOM(ÄrNull([MedlemNr]);0;DSumma("[Betalningsbelopp]";"Fråga Bonus Points";"[MedlemNr]=" & [MedlemNr]))

The question is.
how do I get a report that gives me a list of members oredered from the one member with most points to the one with less points?

Thanks for your help

 

[Calvin]

While in report is in design mode, on the "View" menubar select "Sorting and Grouping" and you can set the field sort order how ever you want: first by Points and in Descending order