Report only displaying 1 out of 4 records

  • Thread starter Thread starter weathermanfsu
  • Start date Start date
W

weathermanfsu

I have a report that only displays one out of 4 records. Te query it
uses shows all 4 records. However, when I look at the report, only one
record is showing up. everything works fine until I add the cell phone
field onto the report. Then it does from 4 records to 1. The cell
phone field can be blank, I am not doing any checks on the field. I do
not know what it is doing this!
 
I'll assume you mean that when you add a table that contains [CellPhone] to
the query underlying your report, you end up with fewer rows.

If your query joins two tables with an "equi-join", you are telling Access
to find ONLY those rows where there's a match on the join field(s). If you
don't have records in the table holding [CellPhone], you won't get the rest.

This assumes two tables, one you're using and a second with a [CellPhone]
field.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
No - there is only one table in the query and cell phone is one of the
fields. They did not include cell phone in the report previously asn
asked me to add it. So I did and then I ran into this problem. Again,
I opened the query this uses as a data source and all 4 records are
displayed. But when i close that and go to the data view the report
only shows 1 record.


Jeff said:
I'll assume you mean that when you add a table that contains [CellPhone] to
the query underlying your report, you end up with fewer rows.

If your query joins two tables with an "equi-join", you are telling Access
to find ONLY those rows where there's a match on the join field(s). If you
don't have records in the table holding [CellPhone], you won't get the rest.

This assumes two tables, one you're using and a second with a [CellPhone]
field.

Regards

Jeff Boyce
Microsoft Office/Access MVP


weathermanfsu said:
I have a report that only displays one out of 4 records. Te query it
uses shows all 4 records. However, when I look at the report, only one
record is showing up. everything works fine until I add the cell phone
field onto the report. Then it does from 4 records to 1. The cell
phone field can be blank, I am not doing any checks on the field. I do
not know what it is doing this!
Click to expand...
Click to expand...
 
?Data view? Are you opening an Access report, or ...?

Regards

Jeff Boyce
Microsoft Office/Access MVP


weathermanfsu said:
No - there is only one table in the query and cell phone is one of the
fields. They did not include cell phone in the report previously asn
asked me to add it. So I did and then I ran into this problem. Again,
I opened the query this uses as a data source and all 4 records are
displayed. But when i close that and go to the data view the report
only shows 1 record.


Jeff said:
I'll assume you mean that when you add a table that contains [CellPhone]
to
the query underlying your report, you end up with fewer rows.

If your query joins two tables with an "equi-join", you are telling
Access
to find ONLY those rows where there's a match on the join field(s). If
you
don't have records in the table holding [CellPhone], you won't get the
rest.

This assumes two tables, one you're using and a second with a [CellPhone]
field.

Regards

Jeff Boyce
Microsoft Office/Access MVP


weathermanfsu said:
I have a report that only displays one out of 4 records. Te query it
uses shows all 4 records. However, when I look at the report, only one
record is showing up. everything works fine until I add the cell phone
field onto the report. Then it does from 4 records to 1. The cell
phone field can be blank, I am not doing any checks on the field. I do
not know what it is doing this!
Click to expand...
Click to expand...
Click to expand...
 
This is a MS Access report. Everything was working fine. It displayed
all 4 records. But then my boss asked me to include the cell phone
field. So I added that field in and then the report (in data view)
would only show 1 record. If I removed the field it would display all
4 records. I checked the query that the report is using to get its
data and it has all 4 records there.


Jeff said:
?Data view? Are you opening an Access report, or ...?

Regards

Jeff Boyce
Microsoft Office/Access MVP


weathermanfsu said:
No - there is only one table in the query and cell phone is one of the
fields. They did not include cell phone in the report previously asn
asked me to add it. So I did and then I ran into this problem. Again,
I opened the query this uses as a data source and all 4 records are
displayed. But when i close that and go to the data view the report
only shows 1 record.


Jeff said:
I'll assume you mean that when you add a table that contains [CellPhone]
to
the query underlying your report, you end up with fewer rows.

If your query joins two tables with an "equi-join", you are telling
Access
to find ONLY those rows where there's a match on the join field(s). If
you
don't have records in the table holding [CellPhone], you won't get the
rest.

This assumes two tables, one you're using and a second with a [CellPhone]
field.

Regards

Jeff Boyce
Microsoft Office/Access MVP


I have a report that only displays one out of 4 records. Te query it
uses shows all 4 records. However, when I look at the report, only one
record is showing up. everything works fine until I add the cell phone
field onto the report. Then it does from 4 records to 1. The cell
phone field can be blank, I am not doing any checks on the field. I do
not know what it is doing this!
Click to expand...
Click to expand...
Click to expand...
 
I'm puzzled too. I don't know of a mechanism that would limit the number of
records in a report based solely on the presence/absence of a single field
from the same query/table.

If checking the filter properties doesn't offer any solution, I'd probably
try building a new report from scratch and see if that one has the same
problem.

Good luck!

Jeff Boyce
Microsoft Office/Access MVP

weathermanfsu said:
This is a MS Access report. Everything was working fine. It displayed
all 4 records. But then my boss asked me to include the cell phone
field. So I added that field in and then the report (in data view)
would only show 1 record. If I removed the field it would display all
4 records. I checked the query that the report is using to get its
data and it has all 4 records there.


Jeff said:
?Data view? Are you opening an Access report, or ...?

Regards

Jeff Boyce
Microsoft Office/Access MVP


weathermanfsu said:
No - there is only one table in the query and cell phone is one of the
fields. They did not include cell phone in the report previously asn
asked me to add it. So I did and then I ran into this problem. Again,
I opened the query this uses as a data source and all 4 records are
displayed. But when i close that and go to the data view the report
only shows 1 record.


Jeff Boyce wrote:
I'll assume you mean that when you add a table that contains
[CellPhone]
to
the query underlying your report, you end up with fewer rows.

If your query joins two tables with an "equi-join", you are telling
Access
to find ONLY those rows where there's a match on the join field(s).
If
you
don't have records in the table holding [CellPhone], you won't get the
rest.

This assumes two tables, one you're using and a second with a
[CellPhone]
field.

Regards

Jeff Boyce
Microsoft Office/Access MVP


I have a report that only displays one out of 4 records. Te query it
uses shows all 4 records. However, when I look at the report, only
one
record is showing up. everything works fine until I add the cell
phone
field onto the report. Then it does from 4 records to 1. The cell
phone field can be blank, I am not doing any checks on the field. I
do
not know what it is doing this!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top