Subreports

[klepto84]

I want to display daily customer "yes" and "no" repsonses in a report showing
the daily results and % breakdown for "yes" and "no" for a date range and the
running total results for totall respones, total "yes", % yes, total "no", %
no.
I have 2 reports created from two separate queries. The first query creates
the daily information. The second query creates the total information.
I've tried to marry these using a subform, but I'm getting garbage.
Any suggestions?

 

[Duane Hookom]

I have a suggestion... please provide your table structure and possibly some
sample records. Then let us know how you would like these sample records to
appear on your report.

 

[klepto84]

The table structure is very simple

Date Total Responses Total "Yes" Total "No"

One query calculates the sum or Total Response, Total "Yes" and Total "No"
for the date ranges.

The other query calculates percentages for yes and no responses.

I want a report that itemizes the daily totals with % (which I have built
from the first query) and I also want to display the percentages for the date
range total i.e. 45 days....I have a second report that does exactly that,
but I want to put this together in one report.

 

[Duane Hookom]

Create two similar subreports and place them in an unbound main report.

 

[klepto84]

I tried to combine the two reports in a number of ways 1/ using the total as
the main report and the detail as the subreport 2/ using the detail as the
main report and dropping the total report in the footer.....

It isn't working.
Can you recommend anything on line that explains subreports in detail? I've
searched the help and combed Access for dummies to no avail.

 

[Duane Hookom]

My suggestion was to simply create two reports. Then add these to a main
report that has no record source.

There really isn't too much to explain about a subreport. It is much like
adding a subform to a main form. You may want to set the Link Master/Child
properties if you want to limit the subreport records to a field value in
the main report.

An important difference between main reports and subreports is that the Main
report hijacks all of the subreport page sections and events. Page header
and footer sections will not display in a subreport.