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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
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.
 
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
 
Back
Top