Need report to only select the "yes" based on month

So you were able to add the extra condition to your report?

Steve is our local troll who ignores the questions asked and tries to
convince posters that they need his help (for a reasonable fee). If you had
responded, he would have found some way of indicating that your tables
needed rework and he was the only one who can do it.

John... Visio MVP
"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

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

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

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

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

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

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

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

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

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