ShirleyLundquist
Technical User
I have a list of birthdays that I want sorted January to December and if possible by day also ... so the birthdays are sequential. Year doesn't matter. I have done it before but can't remember what to do now.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sorting Dates in Access
- Thread starter ShirleyLundquist
- Start date
- Status
Create a query where you take apart month and date with DatePart-function and then sort by month part and day part. Looks in SQL like this:<br>
<br>
SELECT YourBirthdayField, DatePart("m",[YourBirthdayField]) AS BirthMonth, DatePart("d",[YourBirthdayField]) AS BirthDate <br>
FROM [YourTable]<br>
ORDER BY DatePart("m",[YourBirthdayField]), DatePart("d",[YourBirthdayField]);<br>
<br>
Al
<br>
SELECT YourBirthdayField, DatePart("m",[YourBirthdayField]) AS BirthMonth, DatePart("d",[YourBirthdayField]) AS BirthDate <br>
FROM [YourTable]<br>
ORDER BY DatePart("m",[YourBirthdayField]), DatePart("d",[YourBirthdayField]);<br>
<br>
Al
- Status
Similar threads
- Locked
- Question
- Locked
- Question