got it working ..thanks....small modification needed as my interface column had some other entires as well.
i'm using MS acccess..
SELECT F2, LEFT(F3,4) AS interface, COUNT(LEFT(F3,4)) AS aCount FROM
Table1
where F8<>"up / up" GROUP BY F2, LEFT(F3,4) ORDER BY F2, aCount
thanks again.