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

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
samtus@xxxxxxxx



"Hedwig14" <Hedwig14@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@xxxxxxxxxxxxxxxx

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
santus@xxxxxxxx



"John... Visio MVP" <lancucki@xxxxxxxxxxxxx> wrote in message
news:OUkym52$JHA.4376@xxxxxxxxxxxxxxxxxxxxxxx

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@xxxxxxxxxxxxx> wrote
in
message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@xxxxxxxxxxxxxxxx
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
santus@xxxxxxxx




"Hedwig14" <Hedwig14@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@xxxxxxxxxxxxxxxx

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









.

Relevant Pages

  • Re: Creating Access DB
    ... database and in the SQL database that your report needs. ... click the query tab. ...
    (microsoft.public.excel.programming)
  • Re: String Used in Report Displays as Garbage
    ... Is there anything else in the database that has the name ProductCode? ... All the text in the calculated fields in my query are left aligned. ... I tried creating a new report with only the calculated field printed. ... You say the calculation looks fine in the query. ...
    (microsoft.public.access.reports)
  • RE: Database Search Facility
    ... I encountered your posts while researching a solution to my database ... I have had great results from the recommended Ad-Hoc Report! ... > What I specifically want to do is construct a main form with a subform. ... > in the main form and linking them to a query. ...
    (microsoft.public.access.formscoding)
  • Re: Genealogy database
    ... site design (a back end database with a web page user interface) and Access ... I can now do a Query to search (eg Surname ... Taylor) and produce a Report to show the results. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How do I number records in an Access Query?
    ... L A T E that you need to do a pass-through query. ... "John Spencer (MVP)" wrote: ... "Shawn Bauer" wrote: ... our SMS Host database which is FoxPro it has indexes for all tables. ...
    (microsoft.public.access.queries)
Loading