I'm trying to figure out a way I can sort alphabetically ASCENDING while ignoring the Null records. For instance, on a sort by Company, Last Name, First Name, all ascending: The problem is that not all records are attached to a Company, so if I sort Ascending, I have a lot of empty fields at the top of the results. What I'd like to see is the Company, Last Name, First Name, with the Company displayed on top, disregarding the empty Company fields.

I'm sure there's a simple solution whcih escapes me.

Thanks

May be another calc not is Empty (Company, 1,0).

Then sort on that calc first, then by Company Name, LastName, FirstName

I'm not sure I follow you.I create an "IF" to do the sort?

I think what he is saying is, create the calc field, then sort on it first.

Yep. No ?

Okay I'll try that. What is the calculation? Find All notEmpty Company?

Sorry to step on your toes, Ugo. But I have a question.

Todd, do you mean that you don't want to see those records that do not have a company?

If so, I would suggest that you script it. Find for the company field being empty and omit. Then sort by company. If you need help with that, let us know.

Ken

No, I do want to see those records, but in a different order. All of the records have 3 fileds in common: company, last name, first name. Not all of the records use the company field, but still have the first and last name. I'm trying to figure a way to sort by company ascending and have the records with company at the top, instead of all of the empty fields at the top. I need to see all of them, so an Omit won't do the trick.

NP Ken. Right you are I should have asked.

If not, what I was saying, is to create a boolean calculation

c_companysort with formula ----> is NotEmpty(Company).

Actually, there's no need for the 1,0 .

Then use it in your sort criterias as the first one. This would drop at the end of the list those records which aren't companies..

Ah, I see now that makes sense. I'll try it out. Thanks.