> 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.