Mr. Chamberlain Posted November 17, 2005 Posted November 17, 2005 I am trying to sort all records by first name, alphabetically. Some of the records have no first name entered, the field is blank, but I still want them to come up in the sort- but I want them last on the list. This seems like it should be simple but I can't figure it out. The only way I can get those with empty fields to the bottom of the list is to start my sort from Z rather than A. I need A - Z, then blanks. Any help would be appreciated. Thanks,
Sanjai Posted November 17, 2005 Posted November 17, 2005 Create a text calculation field with the following calculation: if(not isempty(FirstName), FirstName, 'zzzz') Sort the records based on the calculation field instead of sorting by first name.
Mr. Chamberlain Posted November 23, 2005 Author Posted November 23, 2005 Sanjai, Thank you for taking the time to respond with your helpful solution,
Recommended Posts
This topic is 6940 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now