SORTING

[Debbie]

HOW DO YOU SORT A DATE SO THAT THE [DOB] SORTS IN BIRTHDAY ORDER FOR
THE YEAR. ANOTHER WORDS, I WANT ALL BIRTHDAYS FOR EACH MONTH TO BE IN
PROPER ORDER BY DATE, DONT CARE ABOUT AGE. THE FIELD IS A PERSONS
DATE OF BIRTH

 

[John Spencer]

Add another field to sort on
Field: SortBy: Format(DOB,"mmdd")
Show: Not Checked
Sort: Ascending

In the SQL statement
SELECT ...
FROM ...
ORDER BY Format(DOB,"mmdd")

 

[Robert_DubYa]

Sounds like you need to define your column as a date. If you can't change
the data in the table use the cdate function in query.

 

[Debbie]

MY COLUMN IS DATE/TIME TYPE

 

[Debbie]

thank you. this works perfectly.

 

[Marshall Barton]

HOW DO YOU SORT A DATE SO THAT THE [DOB] SORTS IN BIRTHDAY ORDER FOR
THE YEAR. ANOTHER WORDS, I WANT ALL BIRTHDAYS FOR EACH MONTH TO BE IN
PROPER ORDER BY DATE, DONT CARE ABOUT AGE. THE FIELD IS A PERSONS
DATE OF BIRTH

Please fix your caps lock key. your question is difficult
to read.

Add a calculated field to the query: Month(DOB) and set its
Sort row to Ascending and uncheck the Show box.

Then add another calculated field: Day(DOB) with the same
settings.