Hi all! I've been searching thru the forum & I can't find my answer; I'm using Crystal Reports 4.6.1.0 that comes free with VB6.0(please forgive me <sg>!)

What I need the report I'm building for a new employee test to do is to break down the specific number of each answer to a survey question; i.e. Yes=1, N/A=2, & No=3 for each question.

How do I build a formula which shows HOW MANY users answered Yes, how many answered N/A, & how many No for each question?

so it will format like:

Question Number: 1
# Yes 4
# N/A 2
# No 3

I've already figured out how to get the Total number or respondents, and the average for each question-I just can't figure the specific formula for the above. Could anyone PLEASE show the SPECIFIC formula I could use for this(this is my first time with Crystal reports!) I'd REALLY appreciate it!