Query

[Guest]

Hi,

I have a table that holds data from a survey that was completed by employees
in our firm. The survey mainly consisted of True/False question/answers.
There are over 50 questions in the survey.

I would like to create a query that lists all employees that selected False
for any of the questions. Is this possible?

Many thanks for any assistance

B

 

[Tom Ellison]

Dear B:

If you have only one column that contains the answers, and not 50
columns, this is easy. You would need a query by employee filtered by
"false" in the answer column. This would show each employee repeated
for each false answer. By then adding DISTINCT to that query, you
would eliminate the reappearance of each employee for each false
answer.

Now, if you have 50 columns for 50 answers, you have not understood
and followed the fundamental rules for database design, and you have
made the job very difficult as a result. There's still hope, but it
will take some effort. I'll try to be merciful to you, but the
database won't.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts