Sorting by month

[Karlos]

hi,

is there any way i can sort my date field by month.

the date is set out in this way dd/mm/yyyy

so is it possible to sort it by month?

cheers in advance

 

[Dan Artuso]

Hi,
If you only want to sort by month, use this Order By:

Order By Month(yourDateField)

 

[Karlos]

excuse me for being dull but how do i do that?

-----Original Message-----
Hi,
If you only want to sort by month, use this Order By:

Order By Month(yourDateField)

--
HTH
Dan Artuso, Access MVP


"Karlos" <[email protected]> wrote in

message news:[email protected]...

 

[Dan Artuso]

Hi,
In the query grid, create a calculated field.

myMonth:Month(yourDateField)

Sort on that field. You don't have to display this field if you don't want to.

If you go into SQL view, this translates into:
Order By Month(yourDateField)

Substitue the real field name for yourDateField