N
nydia
I do have can shrink/can grow on yes. I have 3 tables,
tbl1 is employees (employeeID, department) and table2 is
questions (they have a 1 to many relationship with
employeeID) and comments. table 3 is a list of 12
question. I created a crosstab query that grouped the
questions and showed for each question how many people
answered agree, strongly agree, disagree. Then i created a
query that has the question # with the comments. I
created a main report that was based of the crosstab query
and a sub report based on the comments query. so the
report looks something like this:
1. do you like working here
21 people answered
10 agree
5 disagree
6 did not answer
comments
i like working with my co-workers
If a person 1 and 10 made a comment then there is a
comment on line 1 and then 9 big spaces and then a comment
on line 10. i want the comments to be 1 right after the
other. any suggestions?
do not like my boss
tbl1 is employees (employeeID, department) and table2 is
questions (they have a 1 to many relationship with
employeeID) and comments. table 3 is a list of 12
question. I created a crosstab query that grouped the
questions and showed for each question how many people
answered agree, strongly agree, disagree. Then i created a
query that has the question # with the comments. I
created a main report that was based of the crosstab query
and a sub report based on the comments query. so the
report looks something like this:
1. do you like working here
21 people answered
10 agree
5 disagree
6 did not answer
comments
i like working with my co-workers
If a person 1 and 10 made a comment then there is a
comment on line 1 and then 9 big spaces and then a comment
on line 10. i want the comments to be 1 right after the
other. any suggestions?
do not like my boss
..