Thanks for the help but its not working
I added the reference u told me but had no luck and got the compilation error

i think i can make it work if i figure out how to make query on access

i need a query that counts the amount of
code names without the numbers at the end

ex

AGUIAN001
AGUIAN002
AGUIAN003

COUNT ONLY THE AMOUNT OF
AGUIANXXX