Thanks for your advise and your help.

The following response from ColdCoffee works too:

SELECT LEFT( WkstationID, 3 ) WkstationID , COUNT(*) COUNTS

FROM Workstation

GROUP BY LEFT( WkstationID, 3)

Thank you very much for your kind reply and critique. I will take your advise into consideration.