Part field Use

[Bill Feasey]

I am trying to set up a field which uses two different
field togethe for a new number.
That part is no problem.
however I have a field with 6 numbers and I only want to
use the last 3 as part of my last field.
i.e field [contract]=802569 and [phase]=4

my new field [load] should read = 5694

any ideas

I can do this in lotus approach by right indexing and
stating last 3 digits .

 

[Fredg]

Load=Right([Contract],3) & [Phase]

Look up the Left(), Right(), Mid(), and InStr() functions in Access Help.
They are useful in separating parts of a field.