Sorry, I didn't originally see your response and posted independently. When
I create the query and then refress it does update and I get the required
results on my report but it is now the form that isn't behaving correctly
when I change the query to include "Owned". The form has the checkbox on it
and when I put the "Owned" field into the query and go back to the form the
checkbox is grayed out. The report runs correctly and gives the correct
results but the form doesn't.

"John... Visio MVP" wrote:

Sorry for the delay, things have been a bit busy.
Can you clarify something?
If you create a query with the Owned field, it should be editable, but you
will have to refresh the query to update the table. So, is the form you are
talking about the one used to crate the report or the report itself?

John... Visio MVP
"Hedwig14" wrote in message
...
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