I'm using the following record selection formula in Crystal 8.5 to select data from GoldMine dBase. The formula works OK but I just discovered it is excluding any companies that are blank. I need to exclude companies that contain the three company names I have shown.... and not exclude blank companies. I could sure some help. Thanks! Don
{ContHist.ONDATE} = {?Date_Range} and
not ({Contact1.COMPANY} startswith ["Party Time", "PTR", "CS3"]) and
{ContHist.REF} startswith ["1.", "2.", "3.", "4.", "5.", "6.", "7.", "8."]
{ContHist.ONDATE} = {?Date_Range} and
not ({Contact1.COMPANY} startswith ["Party Time", "PTR", "CS3"]) and
{ContHist.REF} startswith ["1.", "2.", "3.", "4.", "5.", "6.", "7.", "8."]