counting letters

[Dave Lomax]

How do I use a query to count the amount of incidences of
a single letter or sequence of letters in a field?

for instance if I have 1000 entries in a field, each entry
comprising either an 'a', 'b', 'c', or 'd'. How do I count
how many of each letter there are?

Alternatively can I plot a graph based on the same thing
using a wizard?

Many Thanks

Dave Lomax

 

[Lynn Trapp]

Select YourField, Count(YourField) AS CountOfLetters
From YourTable
Group By YourField;