Gabriel,

Your survey responses should be in a table with fields similar to...

RespondentID
QuestionNumber
YesNoAnswer

In other words, the answer to each question should be a separate record
in the table, rather than a separate field. So, to simplify, let's say
you have 2 people respond to the survey, and let's suppose the survey
only has 3 questions for the sake of illustration, then the data in the
table might look like this:

1 1 Yes
1 2 No
1 3 No
2 1 Yes
2 2 Yes
2 3 No

Get the idea? I know your database is probably more complex than this,
with information about the respondents in another table, and the
questions themselves listed in yet another table. But this way of
recording the responses will allow you to easilt create a query that
will show results such as...

Question Response Count
1 Yes 2
1 No 0
2 Yes 1
2 No 1
3 Yes 0
3 No 2

and from this you will be able to produce a "nice report".

--
Steve Schapel, Microsoft Access MVP


GabrielG wrote:
I can consider a revision . What do you recommend?
I need to find the best solution due to the fact that most likely I will be
doing some more of these projects. Like I said before the only data will be
Yes or no answers based on question. The goal will be how many yes and no
answers we can gather and have a nice report. any suggestions?