In a table:
Field 1 contains a 5 digit number
Field 2 contains a name that corresponds to that 5 digit number

I am attempting to write a query to do the following:
Field 1 contains one of the 5 digit numbers.


Field 2 contains the name that corresponds to that 5 digit number
Field 3 performs a calculation on the number in Field 1 (ex. [ITEM]+1)
Field 4 returns the name corresponding to the (new) number that is
the result of the calculation in Field 3

I cannot figure out Field 4
I have tried using a DLookup, but the query is not returning the correct name.