Making a full page form when there isn't enough data

[Kiernan]

I'm trying to replicate a form we utilize at work. The form has 19 rows for individual names with data to be placed next to the names. Most people hand write the information into the blank forms.

All of the information needed to fill in the form is found in a database we use, so I want to recreate the form with a report and populate the rows straight from the database. Not a problem.

But there is. If I only have 10 data entries, it only completes half the page. How do I go about getting the report to fill the page with more blank rows?

If my question isn't clear enough, let me know and I'll try to be more clear.

 

[Kiernan]

Or, better yet, is there a way to make one detail space in a report display multiple records? If I create all the rows in the display area and put the LastName source in the places I want, all I get is a run of Smiths, rather than subsequent records. How can I get it to display them all in one detail area?

 

[Crowley16]

ok, your first question.
I had a similar situation, and what I did was to select some empty rows (SELECT "" AS fldNme) and use a union query to append them to the bottom of the original query, it's not very good but it works...

2nd question.
you need to look into groupings

--------------------
Procrastinate Now!