Locate a value based on 3 fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have field with Participants ages. I need to get the correct LE_VALUE for
that participant. I have 3 fields in one table in my query which are all
Number datatypes.
I need to subtract 10 from the age in turn will give me the correct data in
the BENE_AGE fieled then will give me the correct and final value in the
LE_VALUE FIELD

EXAMPLE

FIELDS

PART_AGE_________BENE_AGE_____________LE_VALUE

85 23 44.3
85 16 47.3
85 75 34.9


notice the Part)_Age has three age 85s? I need to subtract 10 form that age
which in turn will give me 75 as it reads above in turn will give me the
value I am looking for at 34.9. All of the values above are static so I am
basing my query off the data to get my results. I am making a new filed in my
query named Life Expectancy Factor to hold the results.

Anyone up to this challange?

How do I do this?
 
Try this --
SELECT TKM_Age.PART_AGE, TKM_Age.BENE_AGE, TKM_Age.LE_VALUE
FROM TKM_Age
WHERE (((TKM_Age.BENE_AGE)=[PART_AGE]-10));
 
THANK YOU VERY MUCH! PERFECT AS USUAL

KARL DEWEY said:
Try this --
SELECT TKM_Age.PART_AGE, TKM_Age.BENE_AGE, TKM_Age.LE_VALUE
FROM TKM_Age
WHERE (((TKM_Age.BENE_AGE)=[PART_AGE]-10));


TKM said:
I have field with Participants ages. I need to get the correct LE_VALUE for
that participant. I have 3 fields in one table in my query which are all
Number datatypes.
I need to subtract 10 from the age in turn will give me the correct data in
the BENE_AGE fieled then will give me the correct and final value in the
LE_VALUE FIELD

EXAMPLE

FIELDS

PART_AGE_________BENE_AGE_____________LE_VALUE

85 23 44.3
85 16 47.3
85 75 34.9


notice the Part)_Age has three age 85s? I need to subtract 10 form that age
which in turn will give me 75 as it reads above in turn will give me the
value I am looking for at 34.9. All of the values above are static so I am
basing my query off the data to get my results. I am making a new filed in my
query named Life Expectancy Factor to hold the results.

Anyone up to this challange?

How do I do this?
Click to expand...
Click to expand...
 
Back
Top