How can I add rows of colums

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
SELECT Count(yourtable.yourfield) AS CountOfYourfield
FROM yourtable
WHERE (((yourtable.yourfield)="Blue"));
 
Back
Top