Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need Help on Report

Status
Not open for further replies.

kevmi98

Programmer
Apr 20, 2001
5
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top