Force a query to contain 20 records

  • Thread starter Thread starter John S
  • Start date Start date
J

John S

Hello all,

I was wondering if you all could help me out with a
problem that I am having. I am trying to create a report
that will show 20 records per page. To do that I think
that I have to set up a query that automatically forces
itself to have at least 20 lines of output.

Is there any way that I can force a query to show 20 lines
of output even if the recordsource only has 5 lines. The
other 15 lines would then be all blanks, or zero's.

Any help would be greatly appreciated.

Thanks
 
Yes. One method is:

--Have a blank table that contains 20 records. Have the
fields be identical to the output of the main query. Have
a field that counts each row -- numbered from 1 to 20.

Something like:
tblBlankTableCounters
BlankTableCounterID Field1 Field2
1
2
3
....
20

--Have a little query that returns the count of the main
query.

--Create a query that takes the "blanks" table, uses the
query that contains the count of the main table, and have
it return the number of rows neeeded to flush it out to 20
lines. To do this, use a where statement to the effect
of: BlankTableCounterID <=
(qryTotalMainQueryRows.CountOfRealRows Mod 20)

--Union the main query with the blanks query.

David Atkins, MCP
 
What do you mean, Other ways to draw lines in reports?
Cause that is essentially exactly what I am trying to do.

Please help
 
The following prints a 3 inch vertical line. Look up Line
for usage.

Private Sub Report_Page()
Line (0, 0)-(0, 3 * 1440)
End Sub


David Atkins, MCP
 
Back
Top