How can I add rows of colums

[Lorraine]

I am using Access 2002. I have 15 rows (a form using datasheet) of columns
with words such as "Blue", "Dog" are some examples. Under these rows I need
a count of how many "Blues" are in this row and maybe the next column I will
need the count of how many "Dogs" are in these rows. How do you count
words? Help. Also can Access do ratios?

 

[Guest]

SELECT Count(yourtable.yourfield) AS CountOfYourfield
FROM yourtable
WHERE (((yourtable.yourfield)="Blue"));