Bill, Case( not IsEmpty( Inventory 09::ISBN ) ; "Present" ; "Walked" )
Best wishes, Jason L. DeLooze Annapolis, MD USA "You must be the change you want to see in the world" On 6/5/09 at 11:05 AM -0600, Bill Wallace wrote: >> 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
