Repeating field info at top of each page

G

Guest

I've created a report showing who's in what building/location. It sorts by
building, but I don't know how to get the info in each field to repeat at the
top of each page. So if I have 500 people in the "North Tower", the words
"North Tower" only appear once, with everyone listed below. I'd like to have
it repeat at the top of each page where it continues. I tried putting in in
the Page Header, but that doesn't work quite right.

Thanks for any help you can provide.

KK
 
R

Rick B

The page header is the way to do it. What do you mean "that did not work
quite right"?
 
T

tina

here's one solution:

if you haven't already, group your records on the Building field, and in the
Group Properties set the Group Header to Yes. then close the Sorting and
Grouping dialog box. click on the Building Header section of the report. in
the Properties box, set the Repeat Section property to Yes.

hth
 
G

Guest

When I put the field box in the page header, it lists the fieldname
"NorthTower" at the top of each page, but then it doesn't list it further
down the page should the fieldname change, i.e., "South Tower". Tina's
suggestion below worked. I haven't used the "Repeat Section" of the
properties box before. Thanks!

KK
 
G

Guest

Tina, This worked well. Thanks for pointing out that section of the
Properties Box. I hadn't found it before.

KK
 

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