Field with last Name and Company Name

[fhurmuzlu]

I have field named (Lastname) contains Last name and company name and I have 2 texts called name in first text suppose show person's last name and second text supose show same persons' company name or his crew member's name but I only have I field called lastname?
any idea how to solve this problem?
Thanks in advance.

 

[IanWaterman]

Please show example of data.

The function Split() might be able to solve your problem

Ian

 

[Madawc]

You might also need ubound, in case some records just have the one name.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP