too may blank spaces

N

nydia

i have a report with question's and answers and then a
subreport with comments.both report and subreport are
based on queries. this is a database that keeps track of
employee survey.

Problem:
125 people answered the question, person 1 and 5 added
comments, when the report is printed there is a big blank
space in between comment 1 and 5.

how do i do it, so that all the comments are one right
after another and not spaced. It seems like there are 125
spaces for comments and if a comment is not added, it's
left blank, which is leaving alot of blanks on this report.
 
L

Larry Linson

Without some detail about how your data is structured and how your report is
arranged, I can only give you some very generic advice to try the CanShrink
property for the text box in which the comments are displayed.

Larry Linson
Microsoft Access MVP
 
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
 
Top