Sorting Problem (1 Viewer)

Local time
Today, 09:04
Joined
Mar 23, 2022
Messages
45
Hi friends,

I have upload a sample database with query named as "Winner"

While sorting the timing of the race, the timing of the athlete who did not finished the race (Absent, Disqualified and Did Not Finished) appear in the top of the table.

I want to sort the timing in ascending order but at the same time the above athletes who did not finished the race should appear at the bottom.
 

Attachments

  • test.accdb
    1.3 MB · Views: 151

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 20:34
Joined
Oct 29, 2018
Messages
21,613
You could give them a default time that would put them at the bottom. Can you post the SQL statement of your query?
 

June7

AWF VIP
Local time
Yesterday, 19:34
Joined
Mar 9, 2014
Messages
5,503
Calculate a field to use in ORDER BY.

Since Remarks only has comment for DNF records, consider:

ORDER BY IIf([Remarks]="","A","Z"), HeatsScore

I don't allow empty string in text fields but you do and apparently the blanks are empty string not Null.

or suggestion by CJ_London in next post.
 
Last edited:

CJ_London

Super Moderator
Staff member
Local time
Today, 04:34
Joined
Feb 19, 2013
Messages
16,731
Include a calculated field in your query

timing>0

then sort on that before sorting on timing
 

Users who are viewing this thread

Top Bottom