issue that might come up is if you have students with a hyphenated name.
There are ways around that as well.
To extract what you want, simply do a ListFirst(field, "-") to get the
value.
Hatton
I have about 500 rows of data in the table.
What I wish to do is to keep the student names in the rows intact and delete
everything on the righthand side from the -.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
