> After I posted my last message, I tried changing the OR to an AND but it > didn't appear to work. In my test table all records had an S or an F except > for one. It was blank. So I tried: IIF(ALLTRIM(famsingl)!="F" AND > ALLTRIM(famsingl)!="S" ; > OR ISBLANK(famsingl),1,0) AS fblank > This appears to work. But now I wonder why I needed to add the ISBLANK, > shouldn't the expression not equal to F and not equal to S include the > blank record? why just not add a report field with a value Iif(inlist(famsingl),"F","S"),0,1) and calculate its sum in the report? If it has to be just one letter F or S, I assume there may be more letters beyond, so we may add a space: Iif(inlist(famsingl),"F ","S "),0,1) This way you need no additional fields in the select statement.