Order by month - but not what you think!

[deejay_totoro]

Order by month

Hello all,

I am working on a query where there is one field that contains month information.

The data has been stored in this fashion:
01/01/2000

etc...

How might I sort this information in a normal monthly calendar style so that I might use the information properly (and supply the months information correctly for any subsequent reports.)

Thank you very much.

dj_T

 

[Len Boorman]

There is a function called DatePart that will allow you to extract the Month from the date. You could then order by month.

DatePart can extract Day, Month or Year. You should find all the syntax info in the help file but if you have a prob then get back to me

len B

 

[deejay_totoro]

DAte

Thanks for the reply.

Actually - I have tried the following:

nuDate: Format([Month]," yyyy mm")

which allows me to order the data.

Is the correct way to use the Format() function?

Thanks!

dj_T

 

[deejay_totoro]

DAte

Thanks for the reply.

Actually - I have tried the following:

Date: Format([Month]," yyyy mm")

which allows me to order the data.

Is the correct way to use the Format() function?

Thanks!

dj_T

 

[Len Boorman]

Cannot think of why not.

More than one way to do something normally

L

 

[deejay_totoro]

date

Thanks again.

I will also look at your example later.

Cheers!

dj_T