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

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

Guest

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?
 
Your controls are probably in a group header or footer rather than the
detail section where they should be.
 
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.
 
Back
Top