Lookup field, calculate and return new value.

S

Sokan33

I have 2 tables.

Table1
TitelID - Number (ID number from 1 - 60)
TitleDescr - Text

Table2
CurrentTitle Text (Lookup to TitleDescr field in Table1)
AutoRank Text

OBJECTIVE
I want AutoRank field to determine next Title by subtracting 1 from the
TitleID of the CurrentTitle and return the TitleDescr field.

Ex. If 40 is TitleID of CurrentTitle, 39 is the TitleID and it's TitleDecr
is Trader AutoRank should return TRADER. I don't if I'm cracy but I know you
genious out there can make it work.

You inputs will be highly appreciated!
 

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

Similar Threads

Calculated field question - Access 2003 2
Calculated field - Access 2003 2
Using values of a lookup in a calculation 3
Calculated fields and query 0
optimizing sub queries 5
Access left joins returns incorrect rows 3
Returning Empty Field 0
Lookups Help 2

Top