empty rules

J

Jacco Ermers

Hi everyone,

is there a way that if the data has run out but the last page is only half
filled, to have the rest of the rules created empty? Can anyone follow what
I mean? I usually have 14 rules of data per page, on my last page, data (and
with it the columns) stop, leave a empty space, to then create the footer. I
would like to have empty ruless till the end.

Jacco
 
T

Tom Collins

Jacco Ermers said:
Hi everyone,

is there a way that if the data has run out but the last page is only half
filled, to have the rest of the rules created empty? Can anyone follow what
I mean? I usually have 14 rules of data per page, on my last page, data (and
with it the columns) stop, leave a empty space, to then create the footer. I
would like to have empty ruless till the end.

Jacco
Click to expand...

Not real sure what you're trying to do but...
If you mean you have an Access report that's hitting a tables with a list of
rules, then I see 2 solutions.
1) Insert the rules into the table 14 at a time. Have as many of them blank
as necessary. Change the blank ones to real ones as you get them.

2) Have a second table with 19 blank rules. Find out how many blank rules
you need for your report by getting a record count of the rules table and
using the MOD function (20 - (RS.recordcount MOD 20)). Then use a UNION
query with the Rules table and the Blanks table. Use the TOP property with
the query for the Blanks table. This will require VBA.

The second solution is more advanced and may be using things that you've
never used before. It'll be another feather in your cap if you can lookup
how to get it all to work.

Tom Collins
 
Top