Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Array or Parameter or another solution?

Status
Not open for further replies.

purvy

MIS
Aug 10, 2004
1
GB
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
 
what type is the corporate database ?

SQL or Oracle could easily be linked onto access and then used in crystal

Mo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top