Welcome to SPN

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

Sign Up Now!

QUERIES

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

Tags:
  1. Rose

    Rose
    Expand Collapse
    Guest

    On queries I created a file:
    Status Listing # Record #

    On the record # some have data and some have no data.

    I want to open that file with data on the record only.

    Please help.
     
  2. Loading...

    Similar Threads Forum Date
    Importance of Hukamnama - Some Queries Sikh Sikhi Sikhism Jun 14, 2009
    Queries History of Sikhism Oct 26, 2006

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 27 Jun 2006 17:43:04 -0700, Rose
    <Rose@discussions.microsoft.com> wrote:

    >On queries I created a file:
    >Status Listing # Record #


    Could you explain what you mean by "on queries" and what you mean by
    "created a file"? Access queries aren't "files".

    >On the record # some have data and some have no data.
    >
    >I want to open that file with data on the record only.


    Use a criterion of

    IS NOT NULL

    on whichever field or fields should have data.

    John W. Vinson[MVP]
     
  4. Rose

    Rose
    Expand Collapse
    Guest

    Thanks john for your help

    "John Vinson" wrote:

    > On Tue, 27 Jun 2006 17:43:04 -0700, Rose
    > <Rose@discussions.microsoft.com> wrote:
    >
    > >On queries I created a file:
    > >Status Listing # Record #

    >
    > Could you explain what you mean by "on queries" and what you mean by
    > "created a file"? Access queries aren't "files".
    >
    > >On the record # some have data and some have no data.
    > >
    > >I want to open that file with data on the record only.

    >
    > Use a criterion of
    >
    > IS NOT NULL
    >
    > on whichever field or fields should have data.
    >
    > John W. Vinson[MVP]
    >
     

Share This Page