Software

Ask something
Discussion Locked

Access 97 Reports

0 helpful
5 replies

by bowjangles

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to create a report based on two tables that have a one-to-many relationship. For every one record on the report there are many records on the subreport. This works perfectly until there are no related records on the subreport. When this happens a large blank space is printed in the place of the subreport. How can i eliminate this problem. Thank you.

5 replies

by mbarker734

Set the Can Shrink property of the the sub-report to yes. You may also be required to set the individual fields as well.

Good luck,

Mark

by donq

If the answer you rejected won't work for you try basing your report on a "Grouped" query that you test.

by bowjangles

I cannot base my report on a query because of the information i am acquiring from each table is totally different. When i do this information from the first table is omitted. This is why i am using two reports and linking them together

This discussion is closed to new replies.