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.
Thanks, Bill Wallace Bill Wallace Librarian Manzano Day School Albuquerque, NM 87104 School email - [email protected]
