Setting a total height per reccord in a report

G

Guest

I'm using info from two tables to print rolodex cards, which are a fixed
height and fixed number per page. My report contains data from two tables:
one table with family contact info (the header), and one table with people in
that family contact info (detail).
So the card would look like this:

Smith
1005 7th St.
-----------------
John 555-1234
Sue 555-2345

How can I set a total height (no more, no less) for each record
(header+detail), regardless of how many family members each family has
(regardless of how many records the detail section has)?
 
D

Duane Hookom

Consider removing the detail information from your report's recordsource.
Then create a subreport of the detail (people) information. Add the
subreport to the detail section of your main report and don't allow the
detail section to grow.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drawing horizontal lines in Detail Area (Access 2003 xp sp3) 6
Summing a data field for the whole report 3
Two Report Questions 2
Summing expressions per group in a report 3
Sorting and Grouping a Report from Checkboxes 2
Return certain data from Detail area 3
Sum in Report Errors 3
Count or DCount used in a report 1

Top