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

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

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

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

???
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" <(E-Mail Removed)> wrote in message
news624938B-300A-4FE9-9E28-(E-Mail Removed)...
> 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