query for labels (1 Viewer)

[ClaraBarton]

is there a way to insert blank rows into a query that printing labels can start in any label?
I presently insert into a table and then insert blank rows but this seems like I may be missing an easier way.

 

[CJ_London]

Use a union query

Assuming your query is called myquery and you want 5 blanks

Select fld1,fld2, fld3 from myquery
Union all select top 5 null, null, null from myquery

 

[ClaraBarton]

OH! YES! Thank you.

 

[CJ_London]

No problem- although I was asked to do this for a client over 20 years ago to save paper labels (something like 32 labels per sheet) they stopped using it due to the time it took to count the number of labels used and to put the sheet back in the tray (the right way round!) v the cost of the sheet

 

[Gasman]

See this thread https://www.access-programmers.co.u...nd-sometimes-form-prints.284027/#post-1945943