Hi, Using CR 2008 version 12.0.0.683
I have a single table and a list of records. I want to find which records are not in the table.
I've tried: (Equip number list greatly shortened)
I've also tried LBass' solution in thread
And a number of other permutations. Any advice?
Thanks. -brain frozen Bob-
I have a single table and a list of records. I want to find which records are not in the table.
I've tried: (Equip number list greatly shortened)
Code:
// No Equipment record
{EQUIP.SITEID} = "BJH" and
({EQUIP.EQNUM} in
["NE00020283",
"NE00020310",
"SC00021070"])
and IsNull({EQUIP.EQNUM})
Code:
// No Equipment record
{EQUIP.SITEID} = "BJH" and
not({EQUIP.EQNUM} in
["NE00020283",
"NE00020310",
"SC00021070"])
And a number of other permutations. Any advice?
Thanks. -brain frozen Bob-