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 |
#12
|
|||
|
|||
Need report to only select the "yes" based on month
Once again you got a response from the IGNORANT stalker! He flaunts that he
is an MVP but notice it is not in Access. Look at your thread and you will see he provided no help in trying to solve your problem. Ignore the ignorant SOB. Many times in problems posted to the newsgroup, the underlying problem is misdesign of tables. A poster will ask how to do something and most ti,es an answer can be found. However the misdesign of the tables still persists and sooner or later another problem will arise. At his point the misdesign of the tables becomes obvious and a redesign ensues. The redesign then makes a redo of the solution to the first question necessary. If you post your relevant tables in the form of: TblCompany CompanyID CompanyName with a little explanation of your database, I will be glad to give you an evaluation of the design of your tabls. Steve "Hedwig14" wrote in message ... My report is based on a query and my table does have a CompanyName as well as CompanyID...I just didn't mention all the fields in my table as I figured it was not relevant to the question that I needed to be answered. I'm not sure if you still need me to post the query since I have the results that I need. Let me know. "Steve" wrote: Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup but only a harasser. He flaunts that he is an MVP but notice it is not in Access. You mention your table has a field for company name. Correct table design would have a company table with CompanyID and CompanyName. Your table then would have CompanyID rather than company name. Your table would still appear to be incorrect so as previously requested please explain what you want your database to do to clarify so your table design can be further analyzed. Steve "John... Visio MVP" wrote in message ... Stevie, can you actually read? The OP is asking about adding an extra restriction to the query that defines the report. There was no indication that there was anything wrong with the table. To the OP: You are able to select records based on month, so your report should be based on a query. Can you post the query so we can show you how to modify it to include a restriction based on the check mark field. John... Visio MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... Your table appears to not be correct! Please explain what you want your database to do to clarify before you continue and run into more problems. You might have to undo then revise previous thinds in the database. Steve "Hedwig14" wrote in message news I have a table that shows the company name, start date, id number and a check box (yes/no) fields. My report currently allows me to select the month I want to report on but I need for it to only select those records in that month that have a check mark (yes) in the field. I hope you understand what I am trying to say. Thanks in advance |
#13
|
|||
|
|||
Need report to only select the "yes" based on month
Give it up steve, you are just digging your own hole deeper.
So how much will you charge to redesign his "tabls"? John... Visio MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message ... Once again you got a response from the IGNORANT stalker! He flaunts that he is an MVP but notice it is not in Access. Look at your thread and you will see he provided no help in trying to solve your problem. Ignore the ignorant SOB. Many times in problems posted to the newsgroup, the underlying problem is misdesign of tables. A poster will ask how to do something and most ti,es an answer can be found. However the misdesign of the tables still persists and sooner or later another problem will arise. At his point the misdesign of the tables becomes obvious and a redesign ensues. The redesign then makes a redo of the solution to the first question necessary. If you post your relevant tables in the form of: TblCompany CompanyID CompanyName with a little explanation of your database, I will be glad to give you an evaluation of the design of your tabls. Steve "Hedwig14" wrote in message ... My report is based on a query and my table does have a CompanyName as well as CompanyID...I just didn't mention all the fields in my table as I figured it was not relevant to the question that I needed to be answered. I'm not sure if you still need me to post the query since I have the results that I need. Let me know. "Steve" wrote: Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup but only a harasser. He flaunts that he is an MVP but notice it is not in Access. You mention your table has a field for company name. Correct table design would have a company table with CompanyID and CompanyName. Your table then would have CompanyID rather than company name. Your table would still appear to be incorrect so as previously requested please explain what you want your database to do to clarify so your table design can be further analyzed. Steve "John... Visio MVP" wrote in message ... Stevie, can you actually read? The OP is asking about adding an extra restriction to the query that defines the report. There was no indication that there was anything wrong with the table. To the OP: You are able to select records based on month, so your report should be based on a query. Can you post the query so we can show you how to modify it to include a restriction based on the check mark field. John... Visio MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... Your table appears to not be correct! Please explain what you want your database to do to clarify before you continue and run into more problems. You might have to undo then revise previous thinds in the database. Steve "Hedwig14" wrote in message news I have a table that shows the company name, start date, id number and a check box (yes/no) fields. My report currently allows me to select the month I want to report on but I need for it to only select those records in that month that have a check mark (yes) in the field. I hope you understand what I am trying to say. Thanks in advance |
#14
|
|||
|
|||
Need report to only select the "yes" based on month
Steve wrote:
Once again you got a response from the IGNORANT stalker! He flaunts that he is an MVP but notice it is not in Access. Look at your thread and you will see he provided no help in trying to solve your problem. Ignore the ignorant SOB. Many times in problems posted to the newsgroup, the underlying problem is misdesign of tables. A poster will ask how to do something and most ti,es an answer can be found. However the misdesign of the tables still persists and sooner or later another problem will arise. At his point the misdesign of the tables becomes obvious and a redesign ensues. The redesign then makes a redo of the solution to the first question necessary. If you post your relevant tables in the form of: TblCompany CompanyID CompanyName with a little explanation of your database, I will be glad to give you an evaluation of the design of your tabls. Steve "Hedwig14" wrote in message ... My report is based on a query and my table does have a CompanyName as well as CompanyID...I just didn't mention all the fields in my table as I figured it was not relevant to the question that I needed to be answered. I'm not sure if you still need me to post the query since I have the results that I need. Let me know. "Steve" wrote: Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup but only a harasser. He flaunts that he is an MVP but notice it is not in Access. You mention your table has a field for company name. Correct table design would have a company table with CompanyID and CompanyName. Your table then would have CompanyID rather than company name. Your table would still appear to be incorrect so as previously requested please explain what you want your database to do to clarify so your table design can be further analyzed. Steve "John... Visio MVP" wrote in message ... Stevie, can you actually read? The OP is asking about adding an extra restriction to the query that defines the report. There was no indication that there was anything wrong with the table. To the OP: You are able to select records based on month, so your report should be based on a query. Can you post the query so we can show you how to modify it to include a restriction based on the check mark field. John... Visio MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... Your table appears to not be correct! Please explain what you want your database to do to clarify before you continue and run into more problems. You might have to undo then revise previous thinds in the database. Steve "Hedwig14" wrote in message news I have a table that shows the company name, start date, id number and a check box (yes/no) fields. My report currently allows me to select the month I want to report on but I need for it to only select those records in that month that have a check mark (yes) in the field. I hope you understand what I am trying to say. Thanks in advance John is a respected professional with what amounts to an award from Microsoft. Steve evidently isn't, and has given some very questionable advice here. John offers his advice without asking for payment. Steve is constantly touting for paid work, to the great annoyance of the volunteers here. So, do you want an expert's advice, for free, or do you want Steve's offer? Your choice. Phil, London |
#15
|
|||
|
|||
Need report to only select the "yes" based on month
Easier to just ask for clarification than presume you know...
Regards Jeff Boyce Microsoft Office/Access MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message ... Once again you got a response from the IGNORANT stalker! He flaunts that he is an MVP but notice it is not in Access. Look at your thread and you will see he provided no help in trying to solve your problem. Ignore the ignorant SOB. Many times in problems posted to the newsgroup, the underlying problem is misdesign of tables. A poster will ask how to do something and most ti,es an answer can be found. However the misdesign of the tables still persists and sooner or later another problem will arise. At his point the misdesign of the tables becomes obvious and a redesign ensues. The redesign then makes a redo of the solution to the first question necessary. If you post your relevant tables in the form of: TblCompany CompanyID CompanyName with a little explanation of your database, I will be glad to give you an evaluation of the design of your tabls. Steve "Hedwig14" wrote in message ... My report is based on a query and my table does have a CompanyName as well as CompanyID...I just didn't mention all the fields in my table as I figured it was not relevant to the question that I needed to be answered. I'm not sure if you still need me to post the query since I have the results that I need. Let me know. "Steve" wrote: Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup but only a harasser. He flaunts that he is an MVP but notice it is not in Access. You mention your table has a field for company name. Correct table design would have a company table with CompanyID and CompanyName. Your table then would have CompanyID rather than company name. Your table would still appear to be incorrect so as previously requested please explain what you want your database to do to clarify so your table design can be further analyzed. Steve "John... Visio MVP" wrote in message ... Stevie, can you actually read? The OP is asking about adding an extra restriction to the query that defines the report. There was no indication that there was anything wrong with the table. To the OP: You are able to select records based on month, so your report should be based on a query. Can you post the query so we can show you how to modify it to include a restriction based on the check mark field. John... Visio MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... Your table appears to not be correct! Please explain what you want your database to do to clarify before you continue and run into more problems. You might have to undo then revise previous thinds in the database. Steve "Hedwig14" wrote in message news I have a table that shows the company name, start date, id number and a check box (yes/no) fields. My report currently allows me to select the month I want to report on but I need for it to only select those records in that month that have a check mark (yes) in the field. I hope you understand what I am trying to say. Thanks in advance |
#16
|
|||
|
|||
Need report to only select the "yes" based on month
I agree Jeff and I would sooner have all the information to avoid problems
later as these companies are constantly being updated and such. So here goes: Report is based on qryCompanies which is based on Companies as my table. Table = Field Names of CompanyID (Autonumber - Primary Key), CompanyName (Text), BusinessDate (Date/Time), BusinessNumber (Text as we use letters and numbers as identifiers or file numbers), Owned (Yes/No). QryCompanies = Fields are Companies.* and CompanyName (descending) using the Table Companies. On my form the label (Owned) has the Checkbox so this is the one that I would like for the report to only show if it is checked as we are only interested in those companies that are owned. I hope this will help clear things up and guide the correct answer. "Jeff Boyce" wrote: Easier to just ask for clarification than presume you know... Regards Jeff Boyce Microsoft Office/Access MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message ... Once again you got a response from the IGNORANT stalker! He flaunts that he is an MVP but notice it is not in Access. Look at your thread and you will see he provided no help in trying to solve your problem. Ignore the ignorant SOB. Many times in problems posted to the newsgroup, the underlying problem is misdesign of tables. A poster will ask how to do something and most ti,es an answer can be found. However the misdesign of the tables still persists and sooner or later another problem will arise. At his point the misdesign of the tables becomes obvious and a redesign ensues. The redesign then makes a redo of the solution to the first question necessary. If you post your relevant tables in the form of: TblCompany CompanyID CompanyName with a little explanation of your database, I will be glad to give you an evaluation of the design of your tabls. Steve "Hedwig14" wrote in message ... My report is based on a query and my table does have a CompanyName as well as CompanyID...I just didn't mention all the fields in my table as I figured it was not relevant to the question that I needed to be answered. I'm not sure if you still need me to post the query since I have the results that I need. Let me know. "Steve" wrote: Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup but only a harasser. He flaunts that he is an MVP but notice it is not in Access. You mention your table has a field for company name. Correct table design would have a company table with CompanyID and CompanyName. Your table then would have CompanyID rather than company name. Your table would still appear to be incorrect so as previously requested please explain what you want your database to do to clarify so your table design can be further analyzed. Steve "John... Visio MVP" wrote in message ... Stevie, can you actually read? The OP is asking about adding an extra restriction to the query that defines the report. There was no indication that there was anything wrong with the table. To the OP: You are able to select records based on month, so your report should be based on a query. Can you post the query so we can show you how to modify it to include a restriction based on the check mark field. John... Visio MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... Your table appears to not be correct! Please explain what you want your database to do to clarify before you continue and run into more problems. You might have to undo then revise previous thinds in the database. Steve "Hedwig14" wrote in message news I have a table that shows the company name, start date, id number and a check box (yes/no) fields. My report currently allows me to select the month I want to report on but I need for it to only select those records in that month that have a check mark (yes) in the field. I hope you understand what I am trying to say. Thanks in advance |
#17
|
|||
|
|||
Need report to only select the "yes" based on month
Just to expand as well, I use an opening form called frmReportMonthDue which
uses a combo box to select the month with a value list and row source of "January"; "February"; etc. Once you select the month based on the BusinessDate it opens the Report (rptCompanyList). This is the report that I need to have it filter to only list those owned companies that have the checkbox. "Hedwig14" wrote: I agree Jeff and I would sooner have all the information to avoid problems later as these companies are constantly being updated and such. So here goes: Report is based on qryCompanies which is based on Companies as my table. Table = Field Names of CompanyID (Autonumber - Primary Key), CompanyName (Text), BusinessDate (Date/Time), BusinessNumber (Text as we use letters and numbers as identifiers or file numbers), Owned (Yes/No). QryCompanies = Fields are Companies.* and CompanyName (descending) using the Table Companies. On my form the label (Owned) has the Checkbox so this is the one that I would like for the report to only show if it is checked as we are only interested in those companies that are owned. I hope this will help clear things up and guide the correct answer. "Jeff Boyce" wrote: Easier to just ask for clarification than presume you know... Regards Jeff Boyce Microsoft Office/Access MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message ... Once again you got a response from the IGNORANT stalker! He flaunts that he is an MVP but notice it is not in Access. Look at your thread and you will see he provided no help in trying to solve your problem. Ignore the ignorant SOB. Many times in problems posted to the newsgroup, the underlying problem is misdesign of tables. A poster will ask how to do something and most ti,es an answer can be found. However the misdesign of the tables still persists and sooner or later another problem will arise. At his point the misdesign of the tables becomes obvious and a redesign ensues. The redesign then makes a redo of the solution to the first question necessary. If you post your relevant tables in the form of: TblCompany CompanyID CompanyName with a little explanation of your database, I will be glad to give you an evaluation of the design of your tabls. Steve "Hedwig14" wrote in message ... My report is based on a query and my table does have a CompanyName as well as CompanyID...I just didn't mention all the fields in my table as I figured it was not relevant to the question that I needed to be answered. I'm not sure if you still need me to post the query since I have the results that I need. Let me know. "Steve" wrote: Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup but only a harasser. He flaunts that he is an MVP but notice it is not in Access. You mention your table has a field for company name. Correct table design would have a company table with CompanyID and CompanyName. Your table then would have CompanyID rather than company name. Your table would still appear to be incorrect so as previously requested please explain what you want your database to do to clarify so your table design can be further analyzed. Steve "John... Visio MVP" wrote in message ... Stevie, can you actually read? The OP is asking about adding an extra restriction to the query that defines the report. There was no indication that there was anything wrong with the table. To the OP: You are able to select records based on month, so your report should be based on a query. Can you post the query so we can show you how to modify it to include a restriction based on the check mark field. John... Visio MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... Your table appears to not be correct! Please explain what you want your database to do to clarify before you continue and run into more problems. You might have to undo then revise previous thinds in the database. Steve "Hedwig14" wrote in message news I have a table that shows the company name, start date, id number and a check box (yes/no) fields. My report currently allows me to select the month I want to report on but I need for it to only select those records in that month that have a check mark (yes) in the field. I hope you understand what I am trying to say. Thanks in advance |
#18
|
|||
|
|||
Need report to only select the "yes" based on month
Open the query QryCompanies in design view and add True to the Criteria row
for the field [Owned] John... Visio MVP "Hedwig14" wrote in message ... I agree Jeff and I would sooner have all the information to avoid problems later as these companies are constantly being updated and such. So here goes: Report is based on qryCompanies which is based on Companies as my table. Table = Field Names of CompanyID (Autonumber - Primary Key), CompanyName (Text), BusinessDate (Date/Time), BusinessNumber (Text as we use letters and numbers as identifiers or file numbers), Owned (Yes/No). QryCompanies = Fields are Companies.* and CompanyName (descending) using the Table Companies. On my form the label (Owned) has the Checkbox so this is the one that I would like for the report to only show if it is checked as we are only interested in those companies that are owned. I hope this will help clear things up and guide the correct answer. "Jeff Boyce" wrote: Easier to just ask for clarification than presume you know... Regards Jeff Boyce Microsoft Office/Access MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message ... Once again you got a response from the IGNORANT stalker! He flaunts that he is an MVP but notice it is not in Access. Look at your thread and you will see he provided no help in trying to solve your problem. Ignore the ignorant SOB. Many times in problems posted to the newsgroup, the underlying problem is misdesign of tables. A poster will ask how to do something and most ti,es an answer can be found. However the misdesign of the tables still persists and sooner or later another problem will arise. At his point the misdesign of the tables becomes obvious and a redesign ensues. The redesign then makes a redo of the solution to the first question necessary. If you post your relevant tables in the form of: TblCompany CompanyID CompanyName with a little explanation of your database, I will be glad to give you an evaluation of the design of your tabls. Steve "Hedwig14" wrote in message ... My report is based on a query and my table does have a CompanyName as well as CompanyID...I just didn't mention all the fields in my table as I figured it was not relevant to the question that I needed to be answered. I'm not sure if you still need me to post the query since I have the results that I need. Let me know. "Steve" wrote: Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup but only a harasser. He flaunts that he is an MVP but notice it is not in Access. You mention your table has a field for company name. Correct table design would have a company table with CompanyID and CompanyName. Your table then would have CompanyID rather than company name. Your table would still appear to be incorrect so as previously requested please explain what you want your database to do to clarify so your table design can be further analyzed. Steve "John... Visio MVP" wrote in message ... Stevie, can you actually read? The OP is asking about adding an extra restriction to the query that defines the report. There was no indication that there was anything wrong with the table. To the OP: You are able to select records based on month, so your report should be based on a query. Can you post the query so we can show you how to modify it to include a restriction based on the check mark field. John... Visio MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... Your table appears to not be correct! Please explain what you want your database to do to clarify before you continue and run into more problems. You might have to undo then revise previous thinds in the database. Steve "Hedwig14" wrote in message news I have a table that shows the company name, start date, id number and a check box (yes/no) fields. My report currently allows me to select the month I want to report on but I need for it to only select those records in that month that have a check mark (yes) in the field. I hope you understand what I am trying to say. Thanks in advance |
#19
|
|||
|
|||
Need report to only select the "yes" based on month
Unfortunately, I am getting the problem that happened when I first did the
same thing but I added Yes and not True which is that the check box on my form grays out and does not allow me to edit although the report gives me the results that I am looking for. I added the field to my query and added True to the criteria and ran the query which ran fine and the report did what I needed but I have to be able to have the checkbox on my form editable at all times thus to allowing the report to change if a company is removed or no longer owned. Am I supposed to change something on my form with the checkbox as well? "John... Visio MVP" wrote: Open the query QryCompanies in design view and add True to the Criteria row for the field [Owned] John... Visio MVP "Hedwig14" wrote in message ... I agree Jeff and I would sooner have all the information to avoid problems later as these companies are constantly being updated and such. So here goes: Report is based on qryCompanies which is based on Companies as my table. Table = Field Names of CompanyID (Autonumber - Primary Key), CompanyName (Text), BusinessDate (Date/Time), BusinessNumber (Text as we use letters and numbers as identifiers or file numbers), Owned (Yes/No). QryCompanies = Fields are Companies.* and CompanyName (descending) using the Table Companies. On my form the label (Owned) has the Checkbox so this is the one that I would like for the report to only show if it is checked as we are only interested in those companies that are owned. I hope this will help clear things up and guide the correct answer. "Jeff Boyce" wrote: Easier to just ask for clarification than presume you know... Regards Jeff Boyce Microsoft Office/Access MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message ... Once again you got a response from the IGNORANT stalker! He flaunts that he is an MVP but notice it is not in Access. Look at your thread and you will see he provided no help in trying to solve your problem. Ignore the ignorant SOB. Many times in problems posted to the newsgroup, the underlying problem is misdesign of tables. A poster will ask how to do something and most ti,es an answer can be found. However the misdesign of the tables still persists and sooner or later another problem will arise. At his point the misdesign of the tables becomes obvious and a redesign ensues. The redesign then makes a redo of the solution to the first question necessary. If you post your relevant tables in the form of: TblCompany CompanyID CompanyName with a little explanation of your database, I will be glad to give you an evaluation of the design of your tabls. Steve "Hedwig14" wrote in message ... My report is based on a query and my table does have a CompanyName as well as CompanyID...I just didn't mention all the fields in my table as I figured it was not relevant to the question that I needed to be answered. I'm not sure if you still need me to post the query since I have the results that I need. Let me know. "Steve" wrote: Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup but only a harasser. He flaunts that he is an MVP but notice it is not in Access. You mention your table has a field for company name. Correct table design would have a company table with CompanyID and CompanyName. Your table then would have CompanyID rather than company name. Your table would still appear to be incorrect so as previously requested please explain what you want your database to do to clarify so your table design can be further analyzed. Steve "John... Visio MVP" wrote in message ... Stevie, can you actually read? The OP is asking about adding an extra restriction to the query that defines the report. There was no indication that there was anything wrong with the table. To the OP: You are able to select records based on month, so your report should be based on a query. Can you post the query so we can show you how to modify it to include a restriction based on the check mark field. John... Visio MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... Your table appears to not be correct! Please explain what you want your database to do to clarify before you continue and run into more problems. You might have to undo then revise previous thinds in the database. Steve "Hedwig14" wrote in message news I have a table that shows the company name, start date, id number and a check box (yes/no) fields. My report currently allows me to select the month I want to report on but I need for it to only select those records in that month that have a check mark (yes) in the field. I hope you understand what I am trying to say. Thanks in advance |
#20
|
|||
|
|||
Need report to only select the "yes" based on month
Unfortunately, I am getting the problem that happened when I first did the
same thing but I added Yes and not True which is that the check box on my form grays out and does not allow me to edit although the report gives me the results that I am looking for. I added the field to my query and added True to the criteria and ran the query which ran fine and the report did what I needed but I have to be able to have the checkbox on my form editable at all times thus to allowing the report to change if a company is removed or no longer owned. Am I supposed to change something on my form with the checkbox as well? "John... Visio MVP" wrote: Open the query QryCompanies in design view and add True to the Criteria row for the field [Owned] John... Visio MVP "Hedwig14" wrote in message ... I agree Jeff and I would sooner have all the information to avoid problems later as these companies are constantly being updated and such. So here goes: Report is based on qryCompanies which is based on Companies as my table. Table = Field Names of CompanyID (Autonumber - Primary Key), CompanyName (Text), BusinessDate (Date/Time), BusinessNumber (Text as we use letters and numbers as identifiers or file numbers), Owned (Yes/No). QryCompanies = Fields are Companies.* and CompanyName (descending) using the Table Companies. On my form the label (Owned) has the Checkbox so this is the one that I would like for the report to only show if it is checked as we are only interested in those companies that are owned. I hope this will help clear things up and guide the correct answer. "Jeff Boyce" wrote: Easier to just ask for clarification than presume you know... Regards Jeff Boyce Microsoft Office/Access MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message ... Once again you got a response from the IGNORANT stalker! He flaunts that he is an MVP but notice it is not in Access. Look at your thread and you will see he provided no help in trying to solve your problem. Ignore the ignorant SOB. Many times in problems posted to the newsgroup, the underlying problem is misdesign of tables. A poster will ask how to do something and most ti,es an answer can be found. However the misdesign of the tables still persists and sooner or later another problem will arise. At his point the misdesign of the tables becomes obvious and a redesign ensues. The redesign then makes a redo of the solution to the first question necessary. If you post your relevant tables in the form of: TblCompany CompanyID CompanyName with a little explanation of your database, I will be glad to give you an evaluation of the design of your tabls. Steve "Hedwig14" wrote in message ... My report is based on a query and my table does have a CompanyName as well as CompanyID...I just didn't mention all the fields in my table as I figured it was not relevant to the question that I needed to be answered. I'm not sure if you still need me to post the query since I have the results that I need. Let me know. "Steve" wrote: Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup but only a harasser. He flaunts that he is an MVP but notice it is not in Access. You mention your table has a field for company name. Correct table design would have a company table with CompanyID and CompanyName. Your table then would have CompanyID rather than company name. Your table would still appear to be incorrect so as previously requested please explain what you want your database to do to clarify so your table design can be further analyzed. Steve "John... Visio MVP" wrote in message ... Stevie, can you actually read? The OP is asking about adding an extra restriction to the query that defines the report. There was no indication that there was anything wrong with the table. To the OP: You are able to select records based on month, so your report should be based on a query. Can you post the query so we can show you how to modify it to include a restriction based on the check mark field. John... Visio MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... Your table appears to not be correct! Please explain what you want your database to do to clarify before you continue and run into more problems. You might have to undo then revise previous thinds in the database. Steve "Hedwig14" wrote in message news I have a table that shows the company name, start date, id number and a check box (yes/no) fields. My report currently allows me to select the month I want to report on but I need for it to only select those records in that month that have a check mark (yes) in the field. I hope you understand what I am trying to say. Thanks in advance |
Thread Tools | |
Display Modes | |
|
|