Recent content by aiwaxxx

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.

experts, i need some help in writing a query. i have the below table. i need to count the number of INTERFACES starting with FastEthernet2,FastEthernet5 and so on and group them by the NAME column. NAME INTERFACES BE_1-192.168.123.100 FastEthernet2/11 BE_1-192.168.123.100...