incorrect report printout based on query results

  • Thread starter Thread starter Monica
  • Start date Start date
M

Monica

I've created a database that uses two tables with one-to-
many relationships. The query that extracts the
necessary data works great (when I view the query results
in list view, all the data is there). However, when I
create a report to print the query results, some of the
records are left out. Any ideas?
 
Do you have a value in the report's filter property?
Are your controls in the detail section or a header?
 
There are no filters. Controls are located in both
header and detail sections. All controls are either text
boxes or labels.

Any suggestions you have are greatly appreciated.
Thanks,
Monica
 
I have never had records in a report's recordsource that did not show in the
report. I would look at the report record source's datasheet view and see
how many records are returned. Then add a text box to your report header or
footer with a control source of:
=Count(*)
How do these numbers compare?
 
I can't get the totals to show up on the report.

The database that I'm working with holds SDU information
for a school system. Since some teachers take more than
one SDU course each year, the report is designed to print
one page per teacher with multiple courses grouped
together in the detail section. The identification info
for each teacher is in the header section.

The query is retrieving info for each teacher (which I
can see in the datasheet view), but some teachers reports
are not printing.

Thanks again for your time and assistance.

Monica
 
I am not sure what you mean by "can't get the totals toshow up on the
report". If you do like I suggested by placing a text box in the report
header or footer section with a control source of
=Count(*)
you will get a count of the total number of records in the report's record
source. It will not work if you placed the text box in a PAGE header or
footer.
I don't know what you mean by "multiple courses grouped together in the
detail section". The detail section of a report is generally separate from
groupings.
 
I finally figured it out....after correcting my placement
of your =Count(*) suggestion. I actually changed the
sorting and grouping options to make the pages break in
the appropriate places.

Thanks for all your help!
Monica
 
Back
Top