T
Tony
I have set up a table (tbl 1)that has three columns and a
results table (tbl 2) with two columns . The first table
(1) contains two columns with a range and the third
column has a result.
Example Table 1
a b c
Start | Finish | Value
1 | 3 | Good
4 | 6 | Ok
7 | 10 | Bad
On the tbl 2 I have the results
a b
Grade | Value
2.3 |
4.5 |
9.1 |
I am trying to populate the value field on the second
table from the first table. So if the person recived a
2.3 the value on table two should be Good. Please keep in
mind the value will be compared to a range between the
start and finish. The grade will be either a whole value
or a decimal.
Thank you
results table (tbl 2) with two columns . The first table
(1) contains two columns with a range and the third
column has a result.
Example Table 1
a b c
Start | Finish | Value
1 | 3 | Good
4 | 6 | Ok
7 | 10 | Bad
On the tbl 2 I have the results
a b
Grade | Value
2.3 |
4.5 |
9.1 |
I am trying to populate the value field on the second
table from the first table. So if the person recived a
2.3 the value on table two should be Good. Please keep in
mind the value will be compared to a range between the
start and finish. The grade will be either a whole value
or a decimal.
Thank you