Report is not showing all items

  • Thread starter Thread starter Janine
  • Start date Start date
-----Original Message-----
My report is only picking up about 1/3 of the items it
should be. Any suggestions
.
Click to expand...

The most likely culprit is the report's underlying query.
In addition to any specific field criteria, check the join
type of any linked tables. If a link specifies to
find "All records where the joined fields are equal", then
your query will not return records in which this field is
blank or equal to some value not in the joined table
(possible for a lookup in which the Limit to List property
is set to "No").

If this is the problem, how you resolve it depends on
whether you want to allow such records in your table in
the first place. If so, simply change the join type in
your query to return all the records in your main table.
Otherwise, you'll need to devise an appropriate data
validation strategy.

HTH
Kevin Sprinkel
Becker & Frondorf
 
Janine,

Without more information it would be hard to speculate, but I would suggest
starting with the report's recordsource. In report design, open the report
properties and click on the ellipsis (3 dots) to the right of the
recordsource property. This will open the query design window. You may
have unintended criteria in the query that restricts the rows. Change the
query and run it until you get the results you want then save and run the
report again.

HTH,
Josh
 
-----Original Message-----
My report is only picking up about 1/3 of the items it
should be. Any suggestions
.
I am having the same issue, I don't know if it is
Click to expand...
because I need to change relationships or create a new
module or query...
 
Back
Top