I am trying to populate one field based on a seperate field in another table. I am thinking that by using the iIF statement would be the right start. Table 1 has the filed "unitgeology" that holds the text values that i want to use for table 2. The common field for both tables is "holeID". Table 1 and table 2 both have a "from" and a "to" field that has numeric value representing feet. I want to fill a blank field "RockType" in table 2 with the values from "unitgeology" in table 1, but in order to place the right values in the proper order, it has to be based on same "holeID" and between or less than the "from" and "to" fields. As you can see it is a bit confusing, but i would greatly appreciate any help on doing this task. I will discuss this in further detail. thank you