Report Design

[Renee]

I'm having a terrible time with my report design. I've asked this question
before and did not get an answer. FYI: I'm working in Access 2007.

Trying to do... As an example...I want to list a name and address on each
page of my report as the report headers. But then I have another table with
a one-to-many relationship that I want it to list all of it's items related
to this one person's address (as for example, all the trees listed on the
property at that address), then I have another table with a one-to-many
relationship that I want to list all it's items (as for example, all the
flowers listed on the property at that address).

The problem... I can't figure out how to do it without having some
information continually repeating. It's like I need two detail areas in the
design view. One for trees to list the trees and one for the flowers to list
the flowers, but we only get one detail area for the design view.

Any suggestions?

 

[John Spencer]

Try using a subreport for the trees and another for the flowers.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Jeff Boyce]

Renee

In addition to John's suggestion re: subreports, if you have data for which
one/more fields repeats, you can change a property on the control that
displays that field to Hide Duplicates.

Regards

Jeff Boyce
Microsoft Office/Access MVP