two types of sort in one report

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

How do I sort a field in a database desending and others as ascending?
I am making a Record Book for a local High School Athletics Department.
Situation
fields involved: Text field "record" and number field "timed event"
data: to be sorted
1980 most home runs 17 (all in record field)
1981 most home runs 23
1982 most home runs 20
1980 100m dash 12.6 (all in timed event)
1981 100m dash 13.2
1982 100m dash 11.9

how to sort home runs highest to lowest, and 100m dash lowest to highest
in the same report?

HELP!
Dave
 
Are the number of home runs and the time for the dash in the same field?
If not, you can do a mix of ascending and descending in the sorting and
grouping.
If they are in the same field, you can create two calculated fields in a
query based on the event type and sort to taste <g>
 
Dave,


Key info was not explained in your question.

But the last resort catchall is a "Sort field" which you find a way to load
to cause the desired sort.
 
Back
Top