When you say "...because the rest of the data in the record does not merit a
value in the the integer field.", it leads me to believe that the field is a
calcualtion field rather than a straight number field (Filemaker doesn't
actually use "int", "double", etc.). If so, try unchecking, in the
calculation box for the field definition, "Do not evaluate if all referenced
fields are empty". I haven't tested this, but it's a likely place to try. I
do not believe that simply changing the field formatting will make any
difference. Another thing you might try is changing the find criteria to
">=0<1". If neither of those work, you might need an intelligent response.
--
John Weinshel
datagrace
Quote:> Whiles using a find command in an integer field that has only integers
> (finding all values < 1), it returns records that also include null
> values, i.e. there are some records that are blank. They are blank
> because the rest of the data in the record does not merit a value in
> the the integer field. Also the null value does not mean zero either.
> Zero is a valid result.
> I would like to be able to search the integer field for all integers
> include zero but not return the records with the null value.
> Anyone know how this can be done with filemaker 4.0
> Peter
> --
by