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
|
|||
|
|||
Need report to only select the "yes" based on month
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 |
#2
|
|||
|
|||
Need report to only select the "yes" based on month
If you base your report on a query, in that query you can indicate that you
only want records with a check mark (yes) by adding "Yes" to the selection criterion under that field (in the query). Regards Jeff Boyce Microsoft Office/Access MVP "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 |
#3
|
|||
|
|||
Need report to only select the "yes" based on month
How are you currently selecting the Month? Are you modifying a query,
applying a filter, or using a parameter in a query? You need to filter the check box based on whether it is checked (True or -1) or unchecked (False or 0). If you care to share what you are doing then someone can help you further with how to expand that technique. Also, please tell us the name of the check box field. '================================================= === John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County '================================================= === Hedwig14 wrote: 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 |
#4
|
|||
|
|||
Need report to only select the "yes" based on month
I changed my query to include the Yes/No field and ran the query and got the
results I needed and then I included that field on my report to ensure that it was only picking up the "yes" companies and it did so I took that field back out of the report as it is needless to see a column with the word "yes" for every company. Thank you for all your help! "Jeff Boyce" wrote: If you base your report on a query, in that query you can indicate that you only want records with a check mark (yes) by adding "Yes" to the selection criterion under that field (in the query). Regards Jeff Boyce Microsoft Office/Access MVP "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 |
#5
|
|||
|
|||
Need report to only select the "yes" based on month
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 |
#6
|
|||
|
|||
Need report to only select the "yes" based on month
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 |
#7
|
|||
|
|||
Need report to only select the "yes" based on month
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 |
#9
|
|||
|
|||
Need report to only select the "yes" based on month
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 |
#10
|
|||
|
|||
Need report to only select the "yes" based on month
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 | |
|
|