Access 2007: Count Text Items in a Field

[SP]

I have a database with numerous fields. In each field, there is a letter
(i.e. B, B/I, I, A, S,) I need to count the number of each in the fields.
One field is titled Building Design/Contruction Terms with the aboved
mentioned letters. I need to count how many Bs, B/Is, As, etc for each of
the fields. I'd like to run a report that shows:

Building Design/Construction Terms:
20 B
30 B/I
10 A
etc.

Is this possible, I am hitting my head up against a wall now!

 

[Tom van Stiphout]

On Tue, 18 Dec 2007 09:50:03 -0800, SP <[email protected]>
wrote:

Curious you would call "B/I" a letter. But anyway, yes, there is a
simple way to do that: a Totals query.
Create a new query. Click on the capital sigma button to turn it from
a regular select query to a totals query. Drag your field to the grid
twice. Leave the first one at "group by", and set the second one to
"sum".

-Tom.