Removing repeated data

[Stravonian]

I have two fields.

Field 1 contains the names of local authorities

Field 2 contains the names of electoral wards - preceded by the names of the local authority area and " - "

I want to create a new field containing only the names of the wards.

How can I get Access to read the LA names from Field 1 and strip them and " - " from Field 2 and post the resulting text in a new field?

As LA names all vary in length simply stripping out first ?? characters or words doesn't help.

Thanks

 

[plog]

You would use Mid(http://www.techonthenet.com/access/functions/string/mid.php) to extract out the substring of Field 2. Inside of Mid you would use InStr(http://www.techonthenet.com/access/functions/string/instr.php) to find that " - " and use that as the starting position of your substring. Field 1 is irrelevant as long as there are no " - " in any of the values.