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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

In need of assistance - 30 Jun 2006 21:19 GMT

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?

Reply to this Message

Duane Hookom - 30 Jun 2006 21:42 GMT

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

Signature

Duane Hookom
MS Access MVP

> 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
[quoted text clipped - 6 lines]
> report
> only shows the first one. Can someone tell me why?

Reply to this Message

In need of assistance - 30 Jun 2006 22:09 GMT

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.

> Your controls are probably in a group header or footer rather than the
> detail section where they should be.
[quoted text clipped - 9 lines]
> > report
> > only shows the first one. Can someone tell me why?

Reply to this Message