I have the following table

col1  col2  col3  col4
====  ====  ====  =====
1233  4566  ABCD  CDEF 
1233  4566  ACD1  CDEF
1233  4566  D1AF  CDEF

I need to count the characters in col3, so from the data in the previous table it would be:

char  count
====  =====
A         3
B         1
C         2
D         3
F         1
1         2

Is this possible to achieve by using SQL only?

At the moment I am thinking of passing a parameter in to SQL query and count the characters one by one and then sum, however I did not start the VBA part yet, and frankly wouldn't want to do that.

This is my query at the moment:

PARAMETERS X Long;
SELECT First(Mid(TABLE.col3,X,1)) AS [col3 Field], Count(Mid(TABLE.col3,X,1)) AS Dcount
FROM TEST
GROUP BY Mid(TABLE.col3,X,1)
HAVING (((Count(Mid([TABLE].[col3],[X],1)))>=1));

Ideas and help are much appreciated, as I don't usually work with Access and SQL.