I need some help on counting like fields in a record.
I have a form that askes 10 question, there are only 3 answers to choose from for each question. So for each question one chooses either 1,2,or 3 from a drop down list next to the question. (I have 2 tables, one "tblquestions" and one"tblanswers")
Then I have a command button on the form that brings up a report for that individual record only (based on a query) . The report shows that for question 1 they answered "1" and for question 2 they answered "3" etc.
I would like to be able to count the number of #1 answers in the record, and the number of #2 answers, and the number of #3 answers. I would like it to show that of the 10 questions, 5 of the answers were # 1, etc


I understand counting records, but this seems like counting like fields in one record and there I am having trouble. Any suggestions would be great. Thanks