Repeat subreport with out repeating main report

[Granddad]

I'm a newbie to Access and I'm sure this must have come up many times before but searching the forum/internet I couldn't find it...

I want to create a report which shows site information (site record), and then shows monitoring information (monitoring record). The site information and monitoring records are in two tables. I have forms for these set up through queries.

In the report I want the site information to appear once at the top of the report and then the monitoring information to appear below. Because there are multiple monitoring records for each site I need this to repeat for each record. However I'm not sure how to do this correctly. I tried adding both the forms using the subform/subreport but couldn't get anywhere close to what I wanted (especially as I want to run the report off a button in the site information form).

I also created a second report with the site information inserted directly into the report, and the monitoring information as a subreport. This nearly worked except the whole report was repeated for each monitoring record. Is there any way to stop the site information repeating unnecessarily?

I hope that make sense!

Cheers

 

[MarkK]

Hello there and welcome to the forum.

You want in investigate grouping in a report. Write a query that returns all the data you'll need, and then in report design group by the information you want to appear once, and put that in a report header. Then maybe you group by sub-headers, so for each header A you might have many headers B. Finally you get to the detail section of the report, which appears once for each record in the query, and is organized under the appropriate parent header. This is essentially a tree structure.

Makes sense?

In different versions of Access where the menu/ribbon options are to group and sort are quite different, but look around at your menus/ribbons and you'll spot it.

 

[Granddad]

Cheers lagbolt - got it working!