The SQL code is pretty easy, it's making the view builder do it that's the rub. I'm hoping that I'm just overlooking something obvious. I tried typing it into the SQL window and reverse engineering it into the builder, but no such luck.
Gary
>I'm not familiar with view designer but writing something in code I'd write something like this:
>
>
>select c.*, count(*) as cnt from customer c group by customer_id having cnt > 2
>