report not getting all data

[Ann]

I have a report based on a query that gets billing info for customers for a
specified length of time. When I run the query, I get the data for all
customers but when I run the report I only get the data for a few customers.
I have the report grouped by vendor name, ascending. I appreciate any help.
Thanks.

 

[Duane Hookom]

Are your detail controls in your detail section? Are any sections hidden? Is
the any value in the filter property of the report? Are you running any code
in the report? Have you tried adding a text box to the report's Header
Section with a control source of:
=Count(*)
Compare the value with the number of records in your report's query?

 

[Ann]

my detail controls are in the detail section, there are no hidden sections,
there are no filters, there is no code running, i put the text box in the
header with source: =Count(*) and I get the same number of records as in the
query but the report preview only shows some of them and only some print but
not necessarily the same ones as in the preview.

 

[Duane Hookom]

Are you previewing with "Layout Preview" rather than "Print Preview"?

 

[Ann]

I am using "Print Preview"

Are you previewing with "Layout Preview" rather than "Print Preview"?

 

[Duane Hookom]

This has never not worked correctly for me and I have never heard of this
issue beyond the suggestions that I have made. If you continue to have
issues with this report, consider re-creating the report and confirm your
data at each step of the way.

 

[Ann]

thanks

This has never not worked correctly for me and I have never heard of this
issue beyond the suggestions that I have made. If you continue to have
issues with this report, consider re-creating the report and confirm your
data at each step of the way.