Sort By Date - Month Only

[Guest]

Dennis - I did what you suggested and that works - but I ran into a problem.
When I sort it sorts by the year - hoe can I get it to sort by just the day
of the month, don't want to display birth date. After I created the query I
created a form to display the info. In the date field I formated as dd/mmmm
which only shows the date and month but not in chronical order.

Thanks - George

 

[Duane Hookom]

Please don't start a new thread when you have the same question in an
existing thread.

 

[Guest]

You dont have to display the date in the query, just use it for the sort, and
mark it not for display.

 

[John Vinson]

Dennis - I did what you suggested and that works - but I ran into a problem.
When I sort it sorts by the year - hoe can I get it to sort by just the day
of the month, don't want to display birth date. After I created the query I
created a form to display the info. In the date field I formated as dd/mmmm
which only shows the date and month but not in chronical order.

Thanks - George

Put a calculated field in the table:

DayNum: Day([birthdate])

and sort by it.

It will, of course, sort the 3rd of May and the 3rd of April into the
same sort level if your criteria return days from more than one month.

John W. Vinson[MVP]