A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #21  
Old July 9th, 2009, 12:44 PM posted to microsoft.public.access.gettingstarted
Keith Wilby
external usenet poster
 
Posts: 812
Default Need report to only select the "yes" based on month

"Steve" moron_available_at_very_reasonable_rates@contactm e.com wrote in
message ...
Once again you got a response from the IGNORANT stalker!


Yes, and that stalker is YOU.

  #22  
Old July 9th, 2009, 05:14 PM posted to microsoft.public.access.gettingstarted
Hedwig14
external usenet poster
 
Posts: 18
Default Need report to only select the "yes" based on month

Can someone answer my question as to why the checkbox is not editable when I
add the Owned field into the query and report?

"Keith Wilby" wrote:

"Steve" moron_available_at_very_reasonable_rates@contactm e.com wrote in
message ...
Once again you got a response from the IGNORANT stalker!


Yes, and that stalker is YOU.


  #23  
Old July 9th, 2009, 06:46 PM posted to microsoft.public.access.gettingstarted
John... Visio MVP
external usenet poster
 
Posts: 900
Default Need report to only select the "yes" based on month

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

















  #24  
Old July 9th, 2009, 07:34 PM posted to microsoft.public.access.gettingstarted
Hedwig14
external usenet poster
 
Posts: 18
Default Need report to only select the "yes" based on month

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


















  #25  
Old July 9th, 2009, 08:13 PM posted to microsoft.public.access.gettingstarted
John Spencer MVP
external usenet poster
 
Posts: 533
Default Need report to only select the "yes" based on month

Did you add the checkbox to the form?
Is the checkbox bound to any field? It should not be bound to any field or to
any calculation.

Check that the control's Locked property is NO and Enabled property is Yes.

What do you want to happen if the checkbox is not checked? Do you want all
the records or just records where the the value of the field is false?

If you have set the checkbox up to be a triple-state checkbox then it can be
checked (true), unchecked (false), or grayed out (Null)?

If you use a triple-state checkbox on your criteria form, the criteria in the
query would be something like the following to show just the owned or just the
not owned or ALL the records. Triple-State property is found on the Data tab.

Field: Owned
Criteria: Forms![frmReportDue]![NameofCheckboxControl] or
Forms![frmReportDue]![NameofCheckboxControl] is null

You might try opening a new thread with just the problem you are having.
That, hopefully will get you away from all the extraneous comments that are
attached to this thread.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Hedwig14 wrote:
Can someone answer my question as to why the checkbox is not editable when I
add the Owned field into the query and report?

"Keith Wilby" wrote:

"Steve" moron_available_at_very_reasonable_rates@contactm e.com wrote in
message ...
Once again you got a response from the IGNORANT stalker!

Yes, and that stalker is YOU.


  #26  
Old July 9th, 2009, 08:40 PM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Need report to only select the "yes" based on month

On Thu, 9 Jul 2009 09:14:01 -0700, Hedwig14
wrote:

Can someone answer my question as to why the checkbox is not editable when I
add the Owned field into the query and report?


Probably because there's a problem with the Query being used as a
recordsource. If the Owned field is from a different table than that used
before you added it the Join in the query may not be set up correctly. Perhaps
you could post the SQL view of the Recordsource query.

My apologies for your running into the ongoing dispute about Steve's
soliciting. It has nothing to do with you or your question of course.

--

John W. Vinson [MVP]
  #27  
Old July 9th, 2009, 09:50 PM posted to microsoft.public.access.gettingstarted
Hedwig14
external usenet poster
 
Posts: 18
Default Need report to only select the "yes" based on month

I didn't have the checkbox set to be triple-state...once I did that and
selected the proper control source on the form everything worked out nicely!
I didn't want to start a new thread as this seems to have been the final
answer. Thank you and to all that assisted and it sure is nice to see you
pounce out those preditors that try to take advantage of others like me when
we are vulnerable! Cheers

"John Spencer MVP" wrote:

Did you add the checkbox to the form?
Is the checkbox bound to any field? It should not be bound to any field or to
any calculation.

Check that the control's Locked property is NO and Enabled property is Yes.

What do you want to happen if the checkbox is not checked? Do you want all
the records or just records where the the value of the field is false?

If you have set the checkbox up to be a triple-state checkbox then it can be
checked (true), unchecked (false), or grayed out (Null)?

If you use a triple-state checkbox on your criteria form, the criteria in the
query would be something like the following to show just the owned or just the
not owned or ALL the records. Triple-State property is found on the Data tab.

Field: Owned
Criteria: Forms![frmReportDue]![NameofCheckboxControl] or
Forms![frmReportDue]![NameofCheckboxControl] is null

You might try opening a new thread with just the problem you are having.
That, hopefully will get you away from all the extraneous comments that are
attached to this thread.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Hedwig14 wrote:
Can someone answer my question as to why the checkbox is not editable when I
add the Owned field into the query and report?

"Keith Wilby" wrote:

"Steve" moron_available_at_very_reasonable_rates@contactm e.com wrote in
message ...
Once again you got a response from the IGNORANT stalker!
Yes, and that stalker is YOU.



  #28  
Old July 9th, 2009, 10:25 PM posted to microsoft.public.access.gettingstarted
John... Visio MVP
external usenet poster
 
Posts: 900
Default Need report to only select the "yes" based on month

I'm glad you worked it out.

John.. Visio MVP
"Hedwig14" wrote in message
...
I didn't have the checkbox set to be triple-state...once I did that and
selected the proper control source on the form everything worked out
nicely!
I didn't want to start a new thread as this seems to have been the final
answer. Thank you and to all that assisted and it sure is nice to see you
pounce out those preditors that try to take advantage of others like me
when
we are vulnerable! Cheers

"John Spencer MVP" wrote:

Did you add the checkbox to the form?
Is the checkbox bound to any field? It should not be bound to any field
or to
any calculation.

Check that the control's Locked property is NO and Enabled property is
Yes.

What do you want to happen if the checkbox is not checked? Do you want
all
the records or just records where the the value of the field is false?

If you have set the checkbox up to be a triple-state checkbox then it can
be
checked (true), unchecked (false), or grayed out (Null)?

If you use a triple-state checkbox on your criteria form, the criteria in
the
query would be something like the following to show just the owned or
just the
not owned or ALL the records. Triple-State property is found on the
Data tab.

Field: Owned
Criteria: Forms![frmReportDue]![NameofCheckboxControl] or
Forms![frmReportDue]![NameofCheckboxControl] is null

You might try opening a new thread with just the problem you are having.
That, hopefully will get you away from all the extraneous comments that
are
attached to this thread.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Hedwig14 wrote:
Can someone answer my question as to why the checkbox is not editable
when I
add the Owned field into the query and report?

"Keith Wilby" wrote:

"Steve" moron_available_at_very_reasonable_rates@contactm e.com wrote
in
message ...
Once again you got a response from the IGNORANT stalker!
Yes, and that stalker is YOU.





  #29  
Old July 10th, 2009, 01:01 AM posted to microsoft.public.access.gettingstarted
Steve[_72_]
external usenet poster
 
Posts: 190
Default Need report to only select the "yes" based on month

Take a look at all my responses. I was merely questiuoning the OP's table
design and offering to look at what he had and make suggestions if
necessary. Are you going to start standing up for Visio John like some of
your MVP good old boys?

Steve




"John W. Vinson" wrote in message
...
On Thu, 9 Jul 2009 09:14:01 -0700, Hedwig14
wrote:

Can someone answer my question as to why the checkbox is not editable when
I
add the Owned field into the query and report?


Probably because there's a problem with the Query being used as a
recordsource. If the Owned field is from a different table than that used
before you added it the Join in the query may not be set up correctly.
Perhaps
you could post the SQL view of the Recordsource query.

My apologies for your running into the ongoing dispute about Steve's
soliciting. It has nothing to do with you or your question of course.

--

John W. Vinson [MVP]



  #30  
Old July 10th, 2009, 02:01 AM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Need report to only select the "yes" based on month

On Thu, 9 Jul 2009 20:01:16 -0400, "Steve"
help_available_at_very_reasonable_rates@contactme .com wrote:

Take a look at all my responses. I was merely questiuoning the OP's table
design and offering to look at what he had and make suggestions if
necessary. Are you going to start standing up for Visio John like some of
your MVP good old boys?


Calm down, Steve. I'm not defending or attacking either you or John, I'm
regretting that the OP's reasonable post got sucked into the ongoing dispute.
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.