Extract part of string in Field

[garethg]

I am trying to seperate information from one field, and split it int
two fields.

The information looks like this:

ABCDEGH (ZYXWVU) 123

I want to seperate the last three digits of the field so that in
query it would appear in a seperate field.
ANyone

 

[Wayne Morgan]

Check the following in the VBA help file. To get to the VBA help file you have to open a
code window first (Alt+F11), then search the help file.

Left
Right
InStr
Mid
Len

Also useful:
StrComp
StrConv

Right("ABCDEGH (ZYXWVU) 123", 3) will return the last 3 characters (i.e. the 123).