How do I identify an observation from a different row of a data table and use it as a divisor in an expression builder in a MS Access query?
I trying to accomplish this via a series of IIf-functions. What I am trying to do is as follows:
DataField: IIf([value]>0,[observation]/[value]*100,[observation]),
IIf(row=100, observation*200/(row 5 observation here), null),
IIf(row=101, observation*200/(row 5 observation here), null),
IIf(row=103, observation*200/(row 5 observation here), null), etc
The first works all right, but I need a second, third, fourth, etc. which have an expression that uses the observation from a different row.
The syntactical challenge is with part
(row 5 observation here)
How to identify in an expression a specific value from a particular row?
Basically, the data requires a number of observation subjected to different calculation and I would like to have them all in one query.
Thanks a lot for your help.
I trying to accomplish this via a series of IIf-functions. What I am trying to do is as follows:
DataField: IIf([value]>0,[observation]/[value]*100,[observation]),
IIf(row=100, observation*200/(row 5 observation here), null),
IIf(row=101, observation*200/(row 5 observation here), null),
IIf(row=103, observation*200/(row 5 observation here), null), etc
The first works all right, but I need a second, third, fourth, etc. which have an expression that uses the observation from a different row.
The syntactical challenge is with part
(row 5 observation here)
How to identify in an expression a specific value from a particular row?
Basically, the data requires a number of observation subjected to different calculation and I would like to have them all in one query.
Thanks a lot for your help.