And which field is specified for the "first fiield"? c_FullName or EmpID?
Normally, the EmpID is selected for the first field and the name is specified as the second field.
Is c_FUllName a stored (or auto-entered ) calculation?. If you are sorting on the Name field, the field must be stored/indexed or this will not work.
And is the result type for c_FullName number or text?
Thank you for asking that last one, I relised I had it set in the cacluation feild to display a number and not text. It works now! :D