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 .


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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question