empty field

[David Thompson]

>another question of Sylvia was if zero or 0,00 could be separated from
>empty cells, for which I use
>
>" HIDE field b (money) insertfield "a"
>loop right copy left paste downrecord until info("stopped")
>select a="0,00"deletefield "
>
>because select str(b) (or str(b)[1,4]) probably will not work in later
>panorama's. For the selection above, however, macro text is needed.
>
>Is there a shorter way

If you choose Formula Find/Select... from the Search menu, you can 
enter this formula

b=0 AND sizeof("b") > 0

In a procedure you would write that as

Select b=0 AND sizeof("b") > 0

If you wanted to select the empty cells, the formula would be

sizeof("b") = 0

Don't forget to put the quotes around the field name in the sizeof( function.

Dave