Some records in my query do not appear in the associated report

T

TedC

I have a query that draws information from three linked tables. I have used
it as the information source for a report. In testing the report, I
immediately saw that some of the rows from the query were not appearing in
the report.

I don't see any reason why the missing rows wouldn't show up in the report.
Some of them have null columns, but other rows that *do* appear on the report
have nulls in the same columns.

What sort of troubleshooting should I do to correct this problem?
 
D

Duane Hookom

Open your report's record source in datasheet view to view and get a record
count. Then add a text box to the report header or footer with a control
source of:
=Count(*)
Are the values the same?
 
A

Allen Browne

If this happens on Access 2003 with SP1 applied, it could be this problem:
http://support.microsoft.com/?id=840656

Presumably you have ruled out the obvious possibilities, where the report is
being opened with a WhereCondition, or has code that suppressed some values,
or where things CanShrink.
 
L

Larry Linson

Check to make certain that the Row Source of the Reports are identical and
that the DoCmd.OpenReport statements are identical and correct.

A null in a column used as a join might cause the entire record to be
omitted, depending on the join type in the Query.

Larry Linson
Microsoft Access MVP
 
Top