Welcome to SPN

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

Sign Up Now!

Accending month

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

  1. Chey

    Chey
    Expand Collapse
    Guest

    How do I get the month and year in accending order?
    example January 2006, February 2006-December 2007
    Thanks
    Chey
     
  2. Loading...

    Similar Threads Forum Date
    Monthly Fundraiser - Initial Target USD100 Global Announcements Feb 20, 2016
    Welcome to the month of Hell Blogs Oct 17, 2015
    Malaysia Second Malaysian Plane Lost in only 4 months! Breaking News Jul 18, 2014
    UK In eight months the Gurdwara has already made a big impact on Glasgow Breaking News Jan 7, 2014
    India Teenager exposes India's 'one month wives' sex tourism Breaking News Apr 17, 2013

  3. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    If your field is simply a date field with the days taken out then you will be
    able to sort it by clicking the ascending or descending function on the query.

    If your monthfield is Text and you use the ascending or descending options
    then it will sort in alphabetical order

    A simple work-around would be to add another field to the query and insert
    something like

    Month:([NameOfMonthField] & " 1")

    You can then sort THIS field to give you the month fields sorted as you want

    Hope this helps

    --
    Wayne




    "Chey" wrote:

    > How do I get the month and year in accending order?
    > example January 2006, February 2006-December 2007
    > Thanks
    > Chey
     
  4. Ron2006

    Ron2006
    Expand Collapse
    Guest

    If the definition of the field is actually a date then simply sort the
    field ascending.
     
  5. Chey

    Chey
    Expand Collapse
    Guest

    how can I turn this into a date field just showing the month and year?
    The way you explained placed them in alphabetiacal order. But the years
    were in the right order.
    again I would like to see it Jan 05-Dec 05, Jan 06-Dec 06, Jan 07-Dec 07.
    But have all the months actually spelled out in full.
    Thanks for your time.
    Chey

    "Wayne-in-Manchester" wrote:

    > If your field is simply a date field with the days taken out then you will be
    > able to sort it by clicking the ascending or descending function on the query.
    >
    > If your monthfield is Text and you use the ascending or descending options
    > then it will sort in alphabetical order
    >
    > A simple work-around would be to add another field to the query and insert
    > something like
    >
    > Month:([NameOfMonthField] & " 1")
    >
    > You can then sort THIS field to give you the month fields sorted as you want
    >
    > Hope this helps
    >
    > --
    > Wayne
    >
    >
    >
    >
    > "Chey" wrote:
    >
    > > How do I get the month and year in accending order?
    > > example January 2006, February 2006-December 2007
    > > Thanks
    > > Chey
     
  6. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    ???
    You should always use Date fields for Dates - NOT text Fields
    However you can use a function to sort on (might be slow thouugh).
    try the cvdate/CDATE function on your field to see if it helps

    NMH

    Pieter

    BTW
    Format(DateField,"mmmm/YYYY") would show months & year I presume - Check out
    help on format for all listed variants (there are *many* more)

    "Chey" <Chey@discussions.microsoft.com> wrote in message
    news:D624938B-300A-4FE9-9E28-BE091E01E166@microsoft.com...
    > how can I turn this into a date field just showing the month and year?
    > The way you explained placed them in alphabetiacal order. But the years
    > were in the right order.
    > again I would like to see it Jan 05-Dec 05, Jan 06-Dec 06, Jan 07-Dec 07.
    > But have all the months actually spelled out in full.
    > Thanks for your time.
    > Chey
    >
    > "Wayne-in-Manchester" wrote:
    >
    >> If your field is simply a date field with the days taken out then you
    >> will be
    >> able to sort it by clicking the ascending or descending function on the
    >> query.
    >>
    >> If your monthfield is Text and you use the ascending or descending
    >> options
    >> then it will sort in alphabetical order
    >>
    >> A simple work-around would be to add another field to the query and
    >> insert
    >> something like
    >>
    >> Month:([NameOfMonthField] & " 1")
    >>
    >> You can then sort THIS field to give you the month fields sorted as you
    >> want
    >>
    >> Hope this helps
    >>
    >> --
    >> Wayne
    >>
    >>
    >>
    >>
    >> "Chey" wrote:
    >>
    >> > How do I get the month and year in accending order?
    >> > example January 2006, February 2006-December 2007
    >> > Thanks
    >> > Chey
     

Share This Page