order dates

#1

hi
I have a table containing several fields one is a date field
i have summed the data and grouped my month depending on the date field value

what i want to do is order the months in a Chart
the problem is the them date could roll over from one year to the next
ie 2011 to 2012
i want the chart to show themonths from last year in order then the months from this year in order

any ideas how i can do this please

thank

kevin

#2

On 24/01/2012 20:33:21, kevcar40 wrote:

Quote:

hi
I have a table containing several fields one is a date field
i have summed the data and grouped my month depending on the date field
value

what i want to do is order the months in a Chart
the problem is the them date could roll over from one year to the next
ie 2011 to 2012
i want the chart to show themonths from last year in order then the months
from this year in order

any ideas how i can do this please

thank

kevin

Add to your query 2 fields :-

MyYear:Year(MyDate)
MyMonth:Month(MyDate)
then sort y MyYear & MyMonth

Phil

#3

thanks Phil

worked a treat

#4

On Jan 25, 1:05*am, kevcar40 <kevca... (AT) btinternet (DOT) com> wrote:

Quote:

thanks Phil

worked a treat

Compliments to Phil on a good solution

#5

On 25/01/2012 15:03:27, Patrick Finucane wrote:

Quote:

On Jan 25, 1:05*am, kevcar40 <kevca... (AT) btinternet (DOT) com> wrote:
thanks Phil

worked a treat

Compliments to Phil on a good solution

They say with old age comes wisdom.
Plenty of the former, but b.....r all of the later .. but I live & learn.

Phil

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

order dates

comp.databases.ms-access comp.databases.ms-access

order dates - 01-24-2012 , 02:33 PM

Re: order dates - 01-24-2012 , 04:18 PM

Re: order dates - 01-25-2012 , 01:05 AM

Re: order dates - 01-25-2012 , 09:03 AM

Re: order dates - 01-26-2012 , 05:09 PM