Need help sorting data...

[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....

 

[Dirk Goldgar]

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;