too may blank spaces

  • Thread starter Thread starter nydia
  • Start date Start date
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.
 
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
 
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
 
Back
Top