Group Mailing labels on page?

D

diaare

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
 
F

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.
 
5

5167 adress

diaare said:
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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top