T
TKM
I have field with Participants ages. I need to get the correct LE_VALUE
from a fieled in my query. To do this I must subtract 10 from the age of my
participant which will give me the correct BENE_AGE value also from a field
in my query which in turn will give me my final result from the LE_VALUE
field which I will put in my LIFE EXPT field.
EXAMPLE of my query
FIELDS
PART_AGE_________BENE_AGE_____________LE_VALUE
85_________________ 23____________________ 44.3
85_________________ 1_____________________ 47.3
85_________________ 75____________________ 34.9
The query returns my participant at 85 Years old from the PART_AGE field, if
you subtract 10 it will put me on the correct line to get my final result
which in this case be 34.9 Because EACH field has more than one value for
each age all I am trying to do is to get the correct LE_VALUE but I must
follow these steps in order to receive it. I think it is not as hard as it
looks but I am stumped. ANY HELP IS APPRECIATED.
from a fieled in my query. To do this I must subtract 10 from the age of my
participant which will give me the correct BENE_AGE value also from a field
in my query which in turn will give me my final result from the LE_VALUE
field which I will put in my LIFE EXPT field.
EXAMPLE of my query
FIELDS
PART_AGE_________BENE_AGE_____________LE_VALUE
85_________________ 23____________________ 44.3
85_________________ 1_____________________ 47.3
85_________________ 75____________________ 34.9
The query returns my participant at 85 Years old from the PART_AGE field, if
you subtract 10 it will put me on the correct line to get my final result
which in this case be 34.9 Because EACH field has more than one value for
each age all I am trying to do is to get the correct LE_VALUE but I must
follow these steps in order to receive it. I think it is not as hard as it
looks but I am stumped. ANY HELP IS APPRECIATED.