D
dutty2001
Ok let's say that I have 4 fields in a table called D3, D4, D5, and D6.
Each of these columns have a different value (ex: 1.2) to use in
calculations on my form. I also have a field that you use to specify
which kind of "D" information you are using(D VERSION field). So that
data in this field would be like D3 or D5 and so on.
On my report I would like to have a calulated field that would display
the numerical data (ex: 1.2) based on what is found in the D VERSION
field on my report.
So basically let's say on one record the D VERSION field is D5. I need
a function of some sort to take the D5 input and find the corresponding
column name in the table that matches. So once it finds column D5 it
will display the numerical data found in that column. Then I can use
that number in my calculations.
Is there a way to do this? I've tried use IIf functions but my problem
is not as clear cut as If it is named this, then display this. It's
basically a combination of 4 statements like that. If there is a way
to link together the four IIf statements into one that would be great,
but I don't know how to do that.
Please someone help. Thanks very much.
Daniel
Each of these columns have a different value (ex: 1.2) to use in
calculations on my form. I also have a field that you use to specify
which kind of "D" information you are using(D VERSION field). So that
data in this field would be like D3 or D5 and so on.
On my report I would like to have a calulated field that would display
the numerical data (ex: 1.2) based on what is found in the D VERSION
field on my report.
So basically let's say on one record the D VERSION field is D5. I need
a function of some sort to take the D5 input and find the corresponding
column name in the table that matches. So once it finds column D5 it
will display the numerical data found in that column. Then I can use
that number in my calculations.
Is there a way to do this? I've tried use IIf functions but my problem
is not as clear cut as If it is named this, then display this. It's
basically a combination of 4 statements like that. If there is a way
to link together the four IIf statements into one that would be great,
but I don't know how to do that.
Please someone help. Thanks very much.
Daniel