sorting dilema

K

Kelly

I have a birthdate field that looks like 1/16/1990...I want to sort by month,
and then if possible by date...if not possible no biggie. But when I sort
that field it sorts according to year. Any ideas?
 
D

Dan Artuso

Hi,
To sort by month, use a calculated field in your query and sort on that:
In the query grid, add this field:

SortMonth: DatePart("m",[yourDateFieldHere])
then sort on it.

If you want to sort by date as well, make sure that your field is actually a date/time field
and not simply a text field.
 
Top