Recent content by nody88
-
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'. -
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" -
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...