select form table with coeficients

[digit]

how can i use a table and replace a coeficients from that table in a formulas , where the coef. is define as x/y in a table

 

[pdx_man]

Sorry, I don't really understand the question. Coefficient is defined as the numeric part of 4y, where 4 is the coefficient and y is the variable. So then, you have a table with fields defined as:

Tbl_Coeffs
[X_Coeff] Double
[Y_Coeff] Double

where you have values of, say
4 & 6
2.3 & 9

Where your end result would be:

4x/6y
2.3x/9y

Is this what you're looking for? I don't think so, but the grammer is hard to follow. Sorry.

 

[digit]

ok

look .. i have a table with coeficients where horizontal line is year and vertikal is age . and in that table i have a coef. something like that .. iif ([year]=1998 and [age]=25;1.35674;.......)
that coef 1.35674 is in table. im wanna to make a guery which give that coef. automatically not with that bigger script!

 

[pdx_man]

When you say that you have a table, do ou mean that you have an Access Table, or you have a physical chart with the values shown?

If you have an Access table, Then I will tell you how I think it should be structured:

Tbl_Coeff
C_Year Number:Integer
C_Age Number:Byte
Coeff: Number: Double

Then you would have a query:

Select Tbl_Coeff.Value From Tbl_Coeff Where Tbl_Coeff.C_Year = 1998 And Tbl_Coeff.C_Age = 25

You could also have a parameter query with references to controls on a form:

Select Tbl_Coeff.Value From Tbl_Coeff Where Tbl_Coeff.C_Year = Forms!Frm_Selection!TheYear And Tbl_Coeff.C_Age = Forms!Frm_Selection!TheAge

Is this closer to what you are looking for?

 

[digit]

answer

yes this is exactly physical chart with the values shown

 

[digit]

the table is

age\year 10 15 20 25
18 1.256 1.357 1.458 1.598
19 2.254 2.356 2.458 2.569
20 3.258 3.658 3.787 3.985
21 .....................................
22 ....................................
23 ....................................
25 ....................................
... ....................................
... ....................................
70 5.589 5.689 5.865 5.965

and if i have a age = 18 and year = 15 the query must give automaticaly coef 1.357

 

[digit]

the table is

age\year 10 15 20 25
18 1.256 1.357 1.458 1.598
19 2.254 2.356 2.458 2.569
20 3.258 3.658 3.787 3.985
21 .....................................
22 ....................................
23 ....................................
25 ....................................
... ....................................
... ....................................
70 5.589 5.689 5.865 5.965

and if i have a age = 18 and year = 15 the query must give automaticaly coef 1.357

 

[pdx_man]

Then use my table format that I suggested above to load in the values. That should do it for you!