Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Report to Not Show a Record IF a value is=(0)

Discussion in 'Information Technology' started by Corey, Jul 28, 2006.

  1. Corey

    Corey
    Expand Collapse
    Guest

    Is there a way to set a report to not show/print records that have a
    perticular vale that equals ZERO ?
    How can i do this?


    --
    Regards

    Corey
     
  2. Loading...

    Similar Threads Forum Date
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. fredg

    fredg
    Expand Collapse
    Guest

    On Wed, 26 Jul 2006 10:52:13 +1000, Corey wrote:

    > Is there a way to set a report to not show/print records that have a
    > perticular vale that equals ZERO ?
    > How can i do this?


    The proper way is to filter out those records in the report's record
    source query.
    ..... Where YourTable.SomeField <> 0
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. Corey

    Corey
    Expand Collapse
    Guest

    Thanks for the reply Fred.
    Excuse my niavity, but how do i do what you are saying?

    I want the record to be still there in the table, but not to be displayed in
    the report.

    I tried to enter some sort of code into the (Split Belt Table), when to DATA
    SHEET View, and Highlighted the Column that has the values that can be ZERO.
    Then clicked properties, clicked Data and in the filter box enter
    something???

    Is that what you meant??
    The field name is (Length Remainging in Stock), and if this value is (0)
    ZERO then I do not what that entire record to be displayed int he report.



    --
    Regards

    Corey


    "fredg" <fgutkind@example.invalid> wrote in message
    news:xt9yscmvafp3$.qxxky5fqvf4b.dlg@40tude.net...
    > On Wed, 26 Jul 2006 10:52:13 +1000, Corey wrote:
    >
    >> Is there a way to set a report to not show/print records that have a
    >> perticular vale that equals ZERO ?
    >> How can i do this?

    >
    > The proper way is to filter out those records in the report's record
    > source query.
    > .... Where YourTable.SomeField <> 0
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
     
  5. fredg

    fredg
    Expand Collapse
    Guest

    On Wed, 26 Jul 2006 11:53:20 +1000, Corey wrote:

    > Thanks for the reply Fred.
    > Excuse my niavity, but how do i do what you are saying?
    >
    > I want the record to be still there in the table, but not to be displayed in
    > the report.
    >
    > I tried to enter some sort of code into the (Split Belt Table), when to DATA
    > SHEET View, and Highlighted the Column that has the values that can be ZERO.
    > Then clicked properties, clicked Data and in the filter box enter
    > something???
    >
    > Is that what you meant??
    > The field name is (Length Remainging in Stock), and if this value is (0)
    > ZERO then I do not what that entire record to be displayed int he report.


    No! That is not what I mean.

    This is for a report isn't it?

    Open the REPORT in Design View.
    Show the report properties box.
    Click on the Data tab.
    Click on the Record source line.
    Click on the button with the 3 dots on that line.
    The Query Builder will open and display the Show Table dialog box.
    Select the Split Belt Table and add it to the query.

    Drag each field that you need in the report onto the lower panel, one
    field per column (you may need all the fields or just some of them).

    Then, on the [Length Remaining in Stock] Criteria line (in the lower
    panel) write:
    <> 0

    Save this.
    This query then becomes the record source for the report.

    Any record with 0 in the [Length Remaining in Stock] field will not
    appear in the report.

    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     

Share This Page