Where the sql would be something like: SELECT count(status), status FROM table WHERE condition
SELECT count(status), status FROM table GROUP BY status
HTH -- MarkT
========================= E M Thornber CEng MIEE Enchanted Systems Limited Software Toolsmiths +44 (0) 1503 272097
