Crystal Reports Is there way of doing this in Crystal?

Message

     Hi all

I have a table that i'm using Crystal to report on. It basically holds each persons unique reference and whther they were emailed or phoned. People can be emailed and phoned so they can appear repeatedly in the table.

What i'm trying to do is create some sort of formula that can tell how many were ONLY emailed and how many were ONLY phoned.

In SQL you would use an exclude query like

select count(REFERENCE)
from TABLEA
where CONTACT = 'EMAIL'
and REFERENCE NOT IN  (select REFERENCE 
                                  from TABLEA
                                  where CONTACT = 'PHONE')

Does that make sense?

AS far as i know there is no way of using the 'Not in' option.
Does anyone know of any way this can be done??

Any help is much appreciated