If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Records Appear In the Query, But Not On the Report.
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? |
#2
|
|||
|
|||
Records Appear In the Query, But Not On the Report.
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. "Caryn" wrote in message ... 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? |
#3
|
|||
|
|||
Records Appear In the Query, But Not On the Report.
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. "Caryn" wrote in message ... 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? |
#4
|
|||
|
|||
Records Appear In the Query, But Not On the Report.
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. "Caryn" wrote in message ... 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? |
#5
|
|||
|
|||
Records Appear In the Query, But Not On the Report.
"Jeff Boyce" wrote: Caryn Does every single one of your clients have "family members"? 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? 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? 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. "Caryn" wrote in message ... 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? . |
#6
|
|||
|
|||
Records Appear In the Query, But Not On the Report.
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" wrote in message ... "Jeff Boyce" wrote: Caryn Does every single one of your clients have "family members"? 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? 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? 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. "Caryn" wrote in message ... 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? . |
#7
|
|||
|
|||
Records Appear In the Query, But Not On the Report.
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" wrote: 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" wrote in message ... "Jeff Boyce" wrote: Caryn Does every single one of your clients have "family members"? 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? 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? 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. "Caryn" wrote in message ... 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? . . |
#8
|
|||
|
|||
Records Appear In the Query, But Not On the Report.
Also, it appears that the first name that is lower in the alphabet is the one
that appears on the report. "Jeff Boyce" wrote: 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" wrote in message ... "Jeff Boyce" wrote: Caryn Does every single one of your clients have "family members"? 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? 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? 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. "Caryn" wrote in message ... 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? . . |
Thread Tools | |
Display Modes | |
|
|