incorrect report printout based on query results

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?
 
D

Duane Hookom

Do you have a value in the report's filter property?
Are your controls in the detail section or a header?
 
G

Guest

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
 
D

Duane Hookom

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?
 
G

Guest

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
 
D

Duane Hookom

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.
 
M

Monica

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
 

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

Top