My report isn't showing all the records in the query.

  • Thread starter In need of assistance
  • Start date
I

In need of assistance

I've got a report that is fed off of a query that shows the names and
addresses from an address book. However, when I run the report it isn't
showing all the records from the query. The query shows 65 records and the
report only shows 54. Upon closer inspection I found that it is skipping
people that the same last name as a previous record.

For instance even though there are 5 "Johnsons" in the the query, the report
only shows the first one. Can someone tell me why?
 
D

Duane Hookom

Your controls are probably in a group header or footer rather than the
detail section where they should be.
 
I

In need of assistance

Oh jeez, that was spot on. Heh, that was driving me nuts. I'm not sure why
they were in the last name header or even how they got there, but I dropped
them into the detail section and it works perfect now. Thanks for the help.
 
Top