Need help sorting data...

  • Thread starter Thread starter Preston Pierce
  • Start date Start date
P

Preston Pierce

I need to sort my data where the blank entries land at
the bottom of my list not the top. For some reason
access sees the blanks as a higher character than
an "A". Please help....
 
In the query that sorts the table, sort first by IsNull([YourFieldName]
descending, then by [YourFieldName] ascending. For example:

SELECT Table1.* FROM Table1
ORDER BY IsNull([Field1]) DESC , Table1.Field1;
 
Back
Top