Search results

I rewrote it this way. I was thinking that I couldn't use the AND with IIF but it improved the statement. In any case, one must still tab through the parameter in "false" part of IIF but user response has no impact as intended. IIf([Enter Rep#]=1 And [Randomize...

Access 2010, Win7: I'm using an expression in a parameter query to determine the sort order. Actual expression: IIf([Enter Rep#]=1,IIf([Randomize Rep1?]="N",[tblPedigrees.Type_Cross]),Rnd([SSID])) The query fails when [Enter Rep#]>2. The [Randomize Rep1?] parameter still appears even...

I'm a biologist working for a corporation. I've been using Access a little bit now for a few years and if it's possible, I believe I understand less and less each year, er.. day. I'm trying to convert an inherited program for plant breeding into one that more closely follows the rules. Hope to...