Rolodex sort question
I have managed to adapt the rolodex formula to my'enquiries' table. It does a very useful sort of all my surnames on the test database records..
However, I want to add the 'company' field to the sort. At the moment, the calculation looks at the surname of the contact at the company. I want to be able to say If the company field is not empty, then sort by surname and company fields mixed together and if the company field is empty then just sort by surname