Welcome to SPN

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

Sign Up Now!

Query sort on Date!

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

Tags:
  1. Bob

    Bob
    Expand Collapse
    Guest

    I have a query that has 5 fields and I want to sort order on firstly date
    then another field Invoice Number
    If I sort on Invoice number alone any invoices with a zero go to the bottom
    no matter what date it has
    Thanks in advance.........Bob Vance
     
  2. Loading...

    Similar Threads Forum Date
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism a query Book Reviews & Editorials Aug 2, 2005

  3. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    Post the SQL of the query that you've tried. What data types are the "date"
    and "invoice number" fields?

    --

    Ken Snell
    <MS ACCESS MVP>

    "Bob" <xxx@xx.xx> wrote in message news:e8pitj$75e$1@lust.ihug.co.nz...
    >
    >
    > I have a query that has 5 fields and I want to sort order on firstly date
    > then another field Invoice Number
    > If I sort on Invoice number alone any invoices with a zero go to the
    > bottom no matter what date it has
    > Thanks in advance.........Bob Vance
    >
     
  4. Wayne Morgan

    Wayne Morgan
    Expand Collapse
    Guest

    In the query design grid, place the fields you want to sort in left to right
    order. The field on the left should be the one you want to sort first. Next,
    set the sort as desired (ascending or descending). If you need the fields in
    a certain order, such as to fill the columns of a list box, then add the
    fields you want to sort on a second time, set the sort order, and uncheck
    the Show box. This will cause the query to sort on those fields without the
    second copy of them being visible in the query's output. Again, they will be
    sorted as you have them listed from left to right.

    To properly sort a date field, the data type in the table must be set to
    Date/Time.

    --
    Wayne Morgan
    MS Access MVP


    "Bob" <xxx@xx.xx> wrote in message news:e8pitj$75e$1@lust.ihug.co.nz...
    >
    >
    > I have a query that has 5 fields and I want to sort order on firstly date
    > then another field Invoice Number
    > If I sort on Invoice number alone any invoices with a zero go to the
    > bottom no matter what date it has
    > Thanks in advance.........Bob Vance
    >
     
  5. Bob

    Bob
    Expand Collapse
    Guest

    Great Guys Brilliant..thanx Bob

    "Wayne Morgan" <comprev_gothroughthenewsgroup@hotmail.com> wrote in message
    news:%23njnUpvoGHA.3812@TK2MSFTNGP03.phx.gbl...
    > In the query design grid, place the fields you want to sort in left to
    > right order. The field on the left should be the one you want to sort
    > first. Next, set the sort as desired (ascending or descending). If you
    > need the fields in a certain order, such as to fill the columns of a list
    > box, then add the fields you want to sort on a second time, set the sort
    > order, and uncheck the Show box. This will cause the query to sort on
    > those fields without the second copy of them being visible in the query's
    > output. Again, they will be sorted as you have them listed from left to
    > right.
    >
    > To properly sort a date field, the data type in the table must be set to
    > Date/Time.
    >
    > --
    > Wayne Morgan
    > MS Access MVP
    >
    >
    > "Bob" <xxx@xx.xx> wrote in message news:e8pitj$75e$1@lust.ihug.co.nz...
    >>
    >>
    >> I have a query that has 5 fields and I want to sort order on firstly date
    >> then another field Invoice Number
    >> If I sort on Invoice number alone any invoices with a zero go to the
    >> bottom no matter what date it has
    >> Thanks in advance.........Bob Vance
    >>

    >
    >
     

Share This Page