Search results

  1. N

    Use parameter value to evaluate data

    What if for "Purchase" criteria i want to select all the teams which has criteria as 'purchase'? As if i dont want to hard code team values for 'purchase'.
  2. N

    Use parameter value to evaluate data

    in where criteria IIf([Category]="Sales",[rawdata]![team] In ("1","5","9"),[rawdata]![team]="7") giving message as "expression is typed incorrectly or too complex to evaluate"
  3. N

    Use parameter value to evaluate data

    Hello, I am facing a following issue. I have query with a parameter [Category]. Based on this value i wish to select team data like if [Category]="Sale" then (team) in (1,9,5), if [Category]="Purchase" then (team)="7" else (team) in (1,9,5,7). Both the fields team and category are from same...
Back
Top Bottom