I am trying in Crystal 8.5 to get records for those who did not donate in a given date range, but did give in a different date range (i.e. did not donate 5/1/1985 thru 4/30/2009, but did donate 5/1/2009-4/30/2010). Those who meet the criteria are then marked as "new donor". I am getting too many false positives-records who are not "new donors" but are returned as such.
Software/Hardware used:
iMIS 10.6, Crystal 8.5
ASKED:
November 24, 2010 4:36 PM
UPDATED:
November 24, 2010 6:09 PM
We would need to look at your query to be able to offer suggestions. Can you post it ?
Also, what database system are you using ?