query for labels (1 Viewer)

ClaraBarton

Registered User.
Local time
Today, 08:31
Joined
Oct 14, 2019
Messages
703
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.
 
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
 
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
 

Users who are viewing this thread

Back
Top Bottom