I want to sort a column in ascending order, but I want the fields that are null to sort after the numbered fields. I was wondering if anyone may have come across a similar situation. Currently using Access 2003.
Thank You ahead of time,
I want to sort a column in ascending order, but I want the fields that are null to sort after the numbered fields. I was wondering if anyone may have come across a similar situation. Currently using Access 2003.
Thank You ahead of time,
The rules are Nothing comes before something and numbers come before letters
So if you create a query and bring down the field you want to sort and use the following
AliasName:Nz([FieldName],"zzzzzzz")
Then sort ascending
next bring down the original field and view in datasheet mode you should get what you want.
Remember to hide the sort column as this is uneditable.
David