AnsweredAssumed Answered

Rolodex sort question

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

Title

Rolodex sort question

Post

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
Will

 

screen-capture-1.png

Outcomes