Report Order

  • Thread starter Thread starter DD
  • Start date Start date
D

DD

Folks, I have a report that is based off of the QBF
method.

My tables are: tournament (contains a date field)

Players: player ID, and info about the player

Standings: player ID, tournament ID, and a field for
points amount that player was awarded for that tournament.

In my form, users will make a selection based upon
tournament dates.

My report consists of player information and under that,
all of the tournaments that are within the span the user
choose to view.

Everything is working GREAT. And if a user chooses a span
of a year, the report shows the player and tournaments and
points that player achieved for the year.

What I need however, is to put the report in order by
total points awarded (with the player with the most on
top) and if 2 players have the same points amount,
alphabetically.

Time to seek the wise!
Thanks in advance.
 
Sorting (and grouping) in Reports is controlled by the Report's Sorting and
Grouping Properties. These can be accessed by clicking the upper leftmost
little square in design view, then right-clicking, and choosing Sorting and
Grouping. The sort order of the input query is immaterial.

Larry Linson
Microsoft Access MVP
 
Back
Top