Peter Russ skrev: > IMHO at this point group by doesn't make any sense: you should better > use order by and see what you get > > Regs. Peter. > > If I use "order by" I get a single row with the number 4. And I get 4 rows without the count. But this is no good as it will show 3 of the same records on the front end. /BB