F
FL
I can sort records by name within field but, how can I use Access to count
the number of times the field record is repeated? For example: A field has
these records blue, blue, blue, blue, red and red. So my count total will
be 4 blue and 2 red. I have hundreds of records with the same color and
hundreds more of other colors that I would like to total for each color.
Then I can easily do a chart with the totals. Any suggestions on how to
query? Or, can this only be done with a report?
the number of times the field record is repeated? For example: A field has
these records blue, blue, blue, blue, red and red. So my count total will
be 4 blue and 2 red. I have hundreds of records with the same color and
hundreds more of other colors that I would like to total for each color.
Then I can easily do a chart with the totals. Any suggestions on how to
query? Or, can this only be done with a report?