Currently I am using ASPRunner Pro 4.0 (Build 97).
One of the fields of data I am sorting contains numeric values and blank values (i.e the backend database for this column is SQL where the field type is 'float'). For example I may have five records with the corresponding numeric values in the 'Priority' column:
'R' = Record number
R Priority
1 23
2 24
3 1
4
5
When I click on the 'Priority' field to sort they order as following:
R Priority
2 24
1 23
3 1
4
5
This is correct as the the 'Priority' field is sorting in descending order.
If I click on the 'Priority' field again to sort in Ascending order they appear as:
R Priority
4
5
3 1
1 23
2 24
i.e. the records with a blank priority value are listed first.
Is there any way to sort the records in Ascending order so the records with a non-blank value will appear at the top before the blank records. i.e. they sort in Ascending order as follows:
R Priority
3 1
1 23
2 24
4
5
Thanks,
Regards,
Brian