Before I complicate this request with details the point of this is to make a report that displays all entries in a table where the Contact field matches at least one other record's Contact field.


In SQL Query Analyzer I can do this:
select count(*),
  Contact
from Contact1
group by Contact
having count(*) > 1
order by count(*) desc

and I can at least see the name of the people I need to look into.

In MSACCESS I would have just grouped by Contact name and put the count in the group footer and hidden the entire grouping if it was under 2 but I can't seem to do that here.

I tried making a running total field off of Contact and only displaying the ones where it was larger than 2....but since the total count starts each time at 1 I can only display anything past the 2nd copy(3rd, 4th, and all additional).

So...whats the easiest way to do something like this??


Edited by cjbuechler - 24 Oct 2007 at 3:37pm