Records Appear In the Query, But Not On the Report.

  • Thread starter Thread starter Caryn
  • Start date Start date
C

Caryn

I have a table with client names and another table with the family members of
the client. Those are connected via a relationship. I have a query to
generate a list of only those clients who are active as of a certain date. I
have created a report which lists both the clients and the family members
with a left join. However, there are 12 records that are included in the
query, but will not appear on the report. There does not seem to be any
common factor in these records or any specific difference between these
records and the others that appear. I have even attempted deleting the
records and reentering them without success. I know this is sort of a
general question, but does anyone have any idea what could be causing this?
 
Caryn

Does every single one of your clients have "family members"?

What is the SQL statement you are using to see the list of clients plus
family members?

Does your report use that query?

Does your report have a filter turned on?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Jeff Boyce said:
Caryn

Does every single one of your clients have "family members"?
Click to expand...
No they do not all have family members, however records with and without
family members appear on the report.
What is the SQL statement you are using to see the list of clients plus
family members?
Click to expand...
SELECT [Payment Due to Doctor].[IS Last Name], [Payment Due to Doctor].[IS
First Name], [Payment Due to Doctor].[Insured SSN], [Payment Due to
Doctor].[Type of Coverage], [Payment Due to Doctor].[Chosen Dentist],
[Payment Due to Doctor].[Payment Due to Doctor], [Dependant List].[Dependant
Name], [Dependant List].[Date of Birth], [Dependant List].Relationship FROM
[Payment Due to Doctor] LEFT JOIN [Dependant List] ON [Payment Due to
Doctor].[Insured SSN]=[Dependant List].[Primary Insured Information];
Does your report use that query?
Click to expand...
Yes it uses the query. I used a Wizard to format it initially.
 
Caryn

I don't see anything obvious ... hopefully one of the other newsgroup
readers can help with this.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Caryn said:
Jeff Boyce said:
Caryn

Does every single one of your clients have "family members"?
Click to expand...
No they do not all have family members, however records with and without
family members appear on the report.
What is the SQL statement you are using to see the list of clients plus
family members?
Click to expand...
SELECT [Payment Due to Doctor].[IS Last Name], [Payment Due to Doctor].[IS
First Name], [Payment Due to Doctor].[Insured SSN], [Payment Due to
Doctor].[Type of Coverage], [Payment Due to Doctor].[Chosen Dentist],
[Payment Due to Doctor].[Payment Due to Doctor], [Dependant
List].[Dependant
Name], [Dependant List].[Date of Birth], [Dependant List].Relationship
FROM
[Payment Due to Doctor] LEFT JOIN [Dependant List] ON [Payment Due to
Doctor].[Insured SSN]=[Dependant List].[Primary Insured Information];
Does your report use that query?
Click to expand...
Yes it uses the query. I used a Wizard to format it initially.
Does your report have a filter turned on? No.

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.




.
Click to expand...
Click to expand...
 
I attempted changing some of the formats in the original table and it
worked...to a degree. I changed the format part of the date to "Short Date."
It had been blank earlier. Now some of the clients reappeared, but others
disappeared. But a pattern has emerged. It appears that if the clients have
the same last name one or more of them are missing. For example, Nicole
Smith appears, but Kelly and Jessica Smith's records do not. They appear in
the query, but not the report. It feels like I'm so close! Any thoughts?

Jeff Boyce said:
Caryn

I don't see anything obvious ... hopefully one of the other newsgroup
readers can help with this.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Caryn said:
Jeff Boyce said:
Caryn

Does every single one of your clients have "family members"?
Click to expand...
No they do not all have family members, however records with and without
family members appear on the report.
What is the SQL statement you are using to see the list of clients plus
family members?
Click to expand...
SELECT [Payment Due to Doctor].[IS Last Name], [Payment Due to Doctor].[IS
First Name], [Payment Due to Doctor].[Insured SSN], [Payment Due to
Doctor].[Type of Coverage], [Payment Due to Doctor].[Chosen Dentist],
[Payment Due to Doctor].[Payment Due to Doctor], [Dependant
List].[Dependant
Name], [Dependant List].[Date of Birth], [Dependant List].Relationship
FROM
[Payment Due to Doctor] LEFT JOIN [Dependant List] ON [Payment Due to
Doctor].[Insured SSN]=[Dependant List].[Primary Insured Information];
Does your report use that query?
Click to expand...
Yes it uses the query. I used a Wizard to format it initially.
Does your report have a filter turned on? No.

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

I have a table with client names and another table with the family
members
of
the client. Those are connected via a relationship. I have a query to
generate a list of only those clients who are active as of a certain
date.
I
have created a report which lists both the clients and the family
members
with a left join. However, there are 12 records that are included in
the
query, but will not appear on the report. There does not seem to be
any
common factor in these records or any specific difference between these
records and the others that appear. I have even attempted deleting the
records and reentering them without success. I know this is sort of a
general question, but does anyone have any idea what could be causing
this?


.
Click to expand...
Click to expand...


.
Click to expand...
 
Also, it appears that the first name that is lower in the alphabet is the one
that appears on the report.

Jeff Boyce said:
Caryn

I don't see anything obvious ... hopefully one of the other newsgroup
readers can help with this.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Caryn said:
Jeff Boyce said:
Caryn

Does every single one of your clients have "family members"?
Click to expand...
No they do not all have family members, however records with and without
family members appear on the report.
What is the SQL statement you are using to see the list of clients plus
family members?
Click to expand...
SELECT [Payment Due to Doctor].[IS Last Name], [Payment Due to Doctor].[IS
First Name], [Payment Due to Doctor].[Insured SSN], [Payment Due to
Doctor].[Type of Coverage], [Payment Due to Doctor].[Chosen Dentist],
[Payment Due to Doctor].[Payment Due to Doctor], [Dependant
List].[Dependant
Name], [Dependant List].[Date of Birth], [Dependant List].Relationship
FROM
[Payment Due to Doctor] LEFT JOIN [Dependant List] ON [Payment Due to
Doctor].[Insured SSN]=[Dependant List].[Primary Insured Information];
Does your report use that query?
Click to expand...
Yes it uses the query. I used a Wizard to format it initially.
Does your report have a filter turned on? No.

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

I have a table with client names and another table with the family
members
of
the client. Those are connected via a relationship. I have a query to
generate a list of only those clients who are active as of a certain
date.
I
have created a report which lists both the clients and the family
members
with a left join. However, there are 12 records that are included in
the
query, but will not appear on the report. There does not seem to be
any
common factor in these records or any specific difference between these
records and the others that appear. I have even attempted deleting the
records and reentering them without success. I know this is sort of a
general question, but does anyone have any idea what could be causing
this?


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top