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

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

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

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

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

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

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

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

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

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