sorting dilema

[Guest]

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?

 

[Rick B]

=Month([SomeField])
=Date([SomeField])

In your sorting/grouping of the report.

 

[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.