AnsweredAssumed Answered

A to Z Customer Sort

Question asked by SamOsman on Feb 13, 2017
Latest reply on Feb 13, 2017 by SamOsman

Hi,

 

I have a number of buttons on my layout from A to Z to sort a customer list by surname. e.g. Press 'S' button and only customers with the surname beginning with S show. I thought this was working fine, until I have some customers with a surname such as 'Smith Jones' So when the 'J' button is pressed it shows 'Smith Jones' I want it to only find by the first character of the surname field.

 

Currently I have the following: Find Criteria R* for the letter R.

 

How can this be adjusted to only search by the first character of the field?

Outcomes