Sorting by month and day - without year

[TracyBell]

I have a birthdate field which I want to sort by in a report, but I only want it to sort by the month and day - not the year. Is there a way to do this? Do I have to create a query which splits the field somehow? If it's not possible, is there a way to automatically split that field into two or three separate fields, either as one for month and day and the other for year or a separate field for each piece of the date?



Thanks in advance for your help with what's probably a newb question!

[ssanfu]

In a query, use the date functions Month() and Day()........see Help.

Example:

If you have a field named DOB (date of birth), the query might look like

SELECT Employees.EmpLName, Employees.EmpFName, Employees.EmpDOB, Month([EmpDOB]) AS BirthMonth, Day([EmpDOB]) AS BirthDay
FROM Employees
ORDER BY Month([EmpDOB]), Day([EmpDOB]);

(This is one reason why objects should not be named "Month", "Year" or "Day")

[TracyBell]

thanks for your help! It works great.

[DetailDiva]

I'm an Access newbie, and I apologize for my ignorance with this program and with forum etiquette in general........

I used Sql back in the days of DOS with a database, and now I'm trying to translate that knowledge into Access format. I've searched high and low for the information on sorting without year....thanks for the help on that!! I'm making progress slowly but surely.

I can't figure out how to use the group on function in Access......it appears that you leave it blank if you don't want it to group on that field. Correct? Anyway, the real issue is this......how do I get a page break between months? I've tried adding it directly into the SQL view, with no luck.

I've attached a file with a screen shot of the simply query I'm working on. Any help you can offer would be greatly appreciated!