Sorting records based on number...Null values are being sorted fir

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been working on an NCAA Database that holds rankings for teams. Keep
in mind I only assign numbers 1-25 for the top 25 teams in the AP Pole.
However there are 97 teams. I would Like to sort 1-25 firts then the teams
that have null numbers are not assigned a ranking fall behind them. How its
working now is all the unranked teams = null values are being listed first
then the bottom 25 are listed 1-25...Can I get around this problem?
 
Put a computed field in there that uses the IsNull function to return True
or False. Sort on that field first, then on the ranking field.
 
Worked Great, did what you said which either returned a value of -1 or 0 and
sorted on that value first.

Thanks Doug.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rank based on 2 categories 6
Numbering Records from a Query 8
list items from one table in another table based on value in first table 2
Finding the weighted average of text that have been given values 1
Allow Additions Sort Order 3
Ranking Values that Meet a Certain Criteria 3
Sorting and calculating within different fields 8
Points based on goal & weight of measures 2

Back
Top