G
Guest
I have a database which I am using to summarize the results of an employee
survey. I have several tables for entering employee names, survey questions
and the results. I have a query that summarized the results by question and
answer (i.e. agree, disagree etc.). Next, I need a report to display the
results and that is where I am having difficulty.
I am able to create a report with the question in the group header and the
count of answers in the details section and it shows me what I want. The
only problem is that I only want to see the answers for "agree". I tried
writing an expression in the control source box which basically looks like
this [Query1]![Answer Category] ="agree". Can someone tell me what I am
doing wrong. Basically what I am trying to do is to place certain criteria
on the fields of my report without having to create more queries.
Thanks.
survey. I have several tables for entering employee names, survey questions
and the results. I have a query that summarized the results by question and
answer (i.e. agree, disagree etc.). Next, I need a report to display the
results and that is where I am having difficulty.
I am able to create a report with the question in the group header and the
count of answers in the details section and it shows me what I want. The
only problem is that I only want to see the answers for "agree". I tried
writing an expression in the control source box which basically looks like
this [Query1]![Answer Category] ="agree". Can someone tell me what I am
doing wrong. Basically what I am trying to do is to place certain criteria
on the fields of my report without having to create more queries.
Thanks.