Search results

I progressed to the DLookUP direction, which seemed like a promising one and now I have the following: DataField: IIf([value]>0,[observation]/[value]*100,[observation]) Or IIf([TABLE]![row_no]="101",[value]*200/DLookUp("value","TABLE",[TABLE]![row_no]="5"),Null) No error messages with this...

Hi, The data in rows 100 to 110 are calculated differently. The final data column either has (1) percentages or original observations, which are produced by the first IIf function or (2) subdata results for rows 100 to 110, to which the calculation with IIf structure for each row aims to do...

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...

Hi, I am returning back to MS Access and I am hoping to get faster refreshers with your help. Things are going pretty smoothly and progressing fast, but ran into a functional syntax issue and, you all know how it is with those little details. :banghead: Hope you can help and I can help. Check...