AnsweredAssumed Answered

Rolodex sort question

Question asked by willrollo on Sep 12, 2011
Latest reply on Sep 12, 2011 by willrollo


Rolodex sort question


Hi all

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

Any suggestions....?

Thank you