New User needs help with extracting date/part 1

[suzcomptime]

<font color=purple><b>I am a new user and have started a simple database.&nbsp;&nbsp;I have set up a few forms and reports to use but now I need to set up a report that sorts by month and day of birth with no regard for year.&nbsp;&nbsp;I would really appreciate some direction - I tried to set up a query using the date part function but I keep getting errors.&nbsp;&nbsp;<u>Am I even heading in the right direction? Thanks for any help.</b></u></font> <img src=

http://www.Tek-Tips.com/images/happy.gif>

 

[PaulF]

use this in a query as the sort field, where mydate is the date field<br><br>&nbsp;Left(Format([mydate],&quot;mm/dd/yy&quot,5)<br><br>PaulF