Hi,
I have a record in a table that looks like the following
Jack cole;Genwest;771-2700 Jill Code;Genwest;771-2700.
On a report that I am doing I need the names before the ; to be seperated, then where the space is I need a carriage return to go to the next line of that field.
Thank you in advance.
I have a record in a table that looks like the following
Jack cole;Genwest;771-2700 Jill Code;Genwest;771-2700.
On a report that I am doing I need the names before the ; to be seperated, then where the space is I need a carriage return to go to the next line of that field.
Thank you in advance.