Using a "If" and "Then" Statement in Crystal 9

Hi,

Writing code is my weakness so, please bare with me as I give too much info & an attachment. I'm pulling duplicate records from a field that has multiple member types {Member_Types.MEMBER_TYPE} & I need to adjust the report. What I want to do is pull only the duplicate records that contain a duplicate + a valid member type.

1.For example 2 records meet my duplicate criteria & have a member type of GEN & NM - I want to show on the report.
2.But if 2 records meet my duplicate criteria & have a member type of NM & NM - I don't want it to show on the report.

The weird part is it looks like the report is running an SP:{CALL "iMIS"."dbo"."AACAP_GET_DUPLICATE_RECS_SP";1}

Below is the duplicate match key we're using:
UPPER(SUBSTRING(Name.ZIP,1,5) + (CASE WHEN Name.LAST_NAME<>'' THEN (SUBSTRING(Name.LAST_NAME,1,4) + SUBSTRING(Name.FIRST_NAME,1,1)) ELSE SUBSTRING(Name.COMPANY,1,5) END))

I hope I was able to explain that correctly? Any help would be appreciated.

Thanks,

DJ