Hi Bill,
I have reached an impasse with the case function. I would like to
test my inventoried books in my library against my book database.
I used a case function that worked correctly as long as the book
was inventoried.
Case ( Inventory 09::ISBN >50000; "Present";Inventory 09::ISBN=
0;"Walked") Here is the case function that I used. But since there
is no record for a book not inventoried, I cannot ascribe a value
to it. This case function returns a "present" value in the book
database. But the walked or missing books are not there and have no
value to test again. Is there another function that would work better.
I typically use the IsValid() funciton in these cases. That is, as
far as I understand your formula, it would be that:
If ( IsValid( Inventory 09::ISBN );
"Present";
"Walked" )
--
Mikhail Edoshin
[email protected]
