Report with a Sub Report

K

Kim Kautzmann

I have a report that lists store information. My sub report displays
competitors within a mile radius. If there are many competitors the sub
report spills over to a new page but does not display the headings in the
subreport.

I can't seem to find the property that I need to change. Help.
 
J

Jeff Boyce

Kim

Take a look at the "Repeat Section" property ... see if that's what you were
looking for.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

Duane Hookom

I don't think a report header has a "Repeat Section" property. I expect those
are the headings to be repeated.

You can create a new primary sorting and grouping level on a constant like:
=1
Use this as the report/page header and set its Repeat Section property to Yes.
 

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

Similar Threads

Access 2002 change report header text 0
VBA help please 3
Formatting Rule: Diplay Section based on Selection in another section 0
Report: Numbering within reports 0
DB Documentation Report Crashes 0
VBA to look for more than 1 key word and highlights 8
Numbering within reports 0
Lookup value in table from value in report query 13

Top