I have a list of 2800 records of people with (various) postcodes in a corporate database.
I have a separate list of postcodes relating to our borough (7099) records in an access database.
I want to be able, in Crystal, to produce a list of people who are not in our borough (ie their postcodes are not on the Access list).
I've thought about using an array but there are too many records to put into one.
I've tried importing the list as a picklist into a parameter and doing {corresp_address.postcode} in {?postcode} but that doesn't appear to be working properly.
Any help or suggestions would be greatly appreciated!
I'm using Crystal 8.5.
Thanks
I have a separate list of postcodes relating to our borough (7099) records in an access database.
I want to be able, in Crystal, to produce a list of people who are not in our borough (ie their postcodes are not on the Access list).
I've thought about using an array but there are too many records to put into one.
I've tried importing the list as a picklist into a parameter and doing {corresp_address.postcode} in {?postcode} but that doesn't appear to be working properly.
Any help or suggestions would be greatly appreciated!
I'm using Crystal 8.5.
Thanks