Can anybody help me?
I have a query which is qryInterval, and i want to get the data for further computation. Then after that insert/save the output of that computation in that query but in different field.
e.g the values of the qryInterval are the ff:
id interval
1 400
2 600
3 700
Scenario:
1.How will i get that records? Is it possible to use the sql statement (SELECT * FROM qryInterval)?
2.After getting, im going to compute such thing (to get the modulus).
e.g
dim no_day = 365
interval = interval(the data frm. the query) / no_day
....
3. After that, insert the output in the qryinterval (the field is Total_Yr)
Please help!
I have a query which is qryInterval, and i want to get the data for further computation. Then after that insert/save the output of that computation in that query but in different field.
e.g the values of the qryInterval are the ff:
id interval
1 400
2 600
3 700
Scenario:
1.How will i get that records? Is it possible to use the sql statement (SELECT * FROM qryInterval)?
2.After getting, im going to compute such thing (to get the modulus).
e.g
dim no_day = 365
interval = interval(the data frm. the query) / no_day
....
3. After that, insert the output in the qryinterval (the field is Total_Yr)
Please help!
