Group Mailing labels on page?

[Guest]

I have a report set up to print mailing labels. Each record contains the
address info along with a salesrep id. What I would like is each salesreps
labels to start on a new sheet of lables. So that I can hand then out to the
sales reps without cutting them apart.

I have the salesrepid in the page header, along with it in a hidden field in
the label detail.

I have set the sorting and grouping field to salesrepID and have Group On =
Each Value, and Keep Together = Whole Group, but I still get continuous
lables.

What am I missing?
Thanks,
Diane

 

[fredg]

I have a report set up to print mailing labels. Each record contains the
address info along with a salesrep id. What I would like is each salesreps
labels to start on a new sheet of lables. So that I can hand then out to the
sales reps without cutting them apart.

I have the salesrepid in the page header, along with it in a hidden field in
the label detail.

I have set the sorting and grouping field to salesrepID and have Group On =
Each Value, and Keep Together = Whole Group, but I still get continuous
lables.

What am I missing?
Thanks,
Diane

In Report Design View, set the Group's ForceNewPage property to
BeforeSection.

 

[5167 adress]

I have a report set up to print mailing labels. Each record contains the
address info along with a salesrep id. What I would like is each salesreps
labels to start on a new sheet of lables. So that I can hand then out to the
sales reps without cutting them apart.

I have the salesrepid in the page header, along with it in a hidden field in
the label detail.

I have set the sorting and grouping field to salesrepID and have Group On =
Each Value, and Keep Together = Whole Group, but I still get continuous
lables.

What am I missing?
Thanks,
Diane

 

[Gina Whipp]

diaare,

One idea comes to mind... Put a Footer for SalesRepID and in the Footer put
a page break. When doing this make the Footer *just* big enough to fit the
Page Break so your margins don't get messed up OR make your bottom margin
smaller.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm