counting letters

  • Thread starter Thread starter Dave Lomax
  • Start date Start date
D

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
 
Select YourField, Count(YourField) AS CountOfLetters
From YourTable
Group By YourField;
 
Back
Top