Sorry for not being clear so let me reword my question. I need a look up box (or something). first of all there is no formula and I only used height, age and weight as an example. Below is what I am really trying to achieve and I need to do it in Access.

Here we go: If Sch2 is selected and Diam 3" is selected I need for the result to display as 1.93 as shown below. Keep in mind that the next selection could be if Sch1 is selected and Diam 4" is selected the result should display as 4.43. I would like for this to some type of a lookup.

Schedu Diam1 Diam2 Diam3 Diam4 Diam5
    1" 2" 3" 4" 5"
Sch1 1.67 2.33 3.42 4.43 4.76
Sch2 1.76 1.88 1.93 5.25 5.67
Sch3 1.88 1.93 2.15 6.77 6.89
Sch4 1.9 2.2 2.45 3.99 7.33


Michele Haywood

Michele Haywood

__________________
Michele Haywood