SELECT [claimbase].[comp_code],
[claimbase].[ced_comp_pol_num],
[claimbase].[claim_liability],
[claimbase].[date_of_death],
[claimbase].[claim_status]
INTO DeathRecon
FROM [claimbase] Inner Join [AppendAllFields] On [claimbase].[ced_comp_pol_num] = [AppendAllFields].[POL]
WHERE [claimbase].[comp_code] = 'SUN' OR 'CLA' AND <-- Change to In ('SUN', 'CLA')
[claimbase].[claim_status] = 'PAID' AND
[claimbase].[date_of_death] >= #01/01/2003# AND
[claimbase].[date_of_death] <= #01/06/2006# AND
[claimbase].[claim_liability] NOT BETWEEN ([AppendAllFields].[NAR]/100 + 100 ) AND ([AppendAllFields].[NAR]/100 - 100);