Multiple IIF statements returning -1 instead of 1

[BoesFarmers]

When I try to run two iif statements between fields I get a -1 instead of 1. The statements work fine by themselves.

Inactive and Opted-in 2: IIf([enrollment status 2012] Is Null And [enrollment status 2013]="opt-in","1",Null) Or IIf([enrollment status 2012]="opt-out" And [enrollment status 2013]="opt-in","1",Null)

[pbaldy]

I suspect you want:

Inactive and Opted-in 2: IIf(([enrollment status 2012] Is Null Or [enrollment status 2012]="opt-out") And [enrollment status 2013]="opt-in","1",Null)

FYI, spaces and symbols in object names are not worth it in the long run.

[BoesFarmers]

@pbaldy - Thanks. That appears to work. I appreciate the suggestion on spaces and symbols in the object names and will keep that in mind for future builds.

[pbaldy]

No problem. Welcome to the site by the way!