How to select - Not equal to ALL

[Former Member]

I am using Crystal XI and have it linked to another report and an Access database. I want the report to show all records accept the ones listed in the Access database. How do use the select expert to say Not equal to all records in the selected field? I basically want to filter out those records in the access database while showing the records linked from the other report. Looking at around 1,500 records and climbing.

Thanks

[Former Member · Accepted solution]

It should be DB.ID not equal to Access.ID in record selection formula

Raghavendra

[Former Member]

Hi Scott,

Try this in select expert

linking field from DB not equal to linking field from Access

DB.ID<>Access.ID

or try to change the link option "not equal to" in the links tab

Regards,

Raghavendra

[Former Member]

NOT({table.field} IN {?parameter array})