How keep blank non-existent records from appearing in sub-report?

A

Arrowhead

I am using Access 2003 in XP. My Customer Contact Reports have basic
Customer info at the top (from the Customer Table filled with info), and in
the bottom sub-report any Contact(s) info (from the Contact Table). Since I
have not yet deployed this database to my client (due to the problem I am
seeking help on), there are only two Contacts in the Contacts Table.
However, when I navigate through the Reports, occassionally additional blank
Contact records will appear (otherwise only one formatted blank record is
displayed) and when there are a sufficient number of them they will then
spill over into a second page. There are no blank Contact records in the
Contacts Table, so how can I prevent this buildup?
 
M

Marshall Barton

Arrowhead said:
I am using Access 2003 in XP. My Customer Contact Reports have basic
Customer info at the top (from the Customer Table filled with info), and in
the bottom sub-report any Contact(s) info (from the Contact Table). Since I
have not yet deployed this database to my client (due to the problem I am
seeking help on), there are only two Contacts in the Contacts Table.
However, when I navigate through the Reports, occassionally additional blank
Contact records will appear (otherwise only one formatted blank record is
displayed) and when there are a sufficient number of them they will then
spill over into a second page. There are no blank Contact records in the
Contacts Table, so how can I prevent this buildup?


A report can not make up nonexistent records. If there
truely are no blank records in the table, then there's
probably something odd in the subreport's record source
query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top