Labels starting mid-way through a sheet?

[RomeoJuliet]

I have used the Label Wizard to create a pretty standard labels report laid out to suit a specific Avery format (3 across by 7 down on an A4 sheet). However, I'm calling the report from a form on which I want to place a control asking the user to select a starting label from 1 to 21 (where 1 is top left, and counting across then down, just like the report itself). The reason being that this will allow the user to perform many short report runs and be able to use up all the labels on each sheet (it's for a non-profit-making organisation which needs to save money!).

Any guidance on how to 'pad out' the start of the report would be very welcome. For instance, if the user says 'start at position 7' I'm thinking I will need to 'print' 6 empty records before starting on the 'real' data... but I'm not sure how to set about this.

Many thanks
Mike.

 

[CraigDolphin]

Hmm. Conceptually, you could use code to create a temp table with the requisite number of (presumably empty) rows. Then use a SQL Union query to combine the emptry rows in the temp table, with the existing rowsource for your report. Then use the results of that union query as the rowsource for your report instead.

HTH

 

[RomeoJuliet]

Many thanks CraigDolphin, this works absolutely perfectly.

All the best
Mike.

 

[CraigDolphin]

Glad I could help