Month/Day from DOB in a query (help)

[pujo]

Hello group.

I have a table field "Date of Birth", format mm/dd/yyyy
In a query, I would like to extract only the month and day sorted by month (Jan thru Dec).
This is just a birthday list that I am trying to make.

Cannot figure out the syntax to get it done...

It's been a long, long time since I worked with queries, please help if you can.

Thanks,
PuJo

 

[mole999]

basically
your dispalycell = text(yourdate,"mmmm - dd"

you might need
your dispalycell = text(yourdate,"mm - mmmm - dd" to sort in a cell

That of course the excel way (Again i'm reading access questions oops)

 

[pujo]

Thanks for the quickness, and great answer.
I still have the sorting problem. I wanted to sort from Jan to Dec but the dates are all over the place...

Any ideas?

Current sorting the month by first letter, (April, August, December....)

 

[mole999]

well your doing this in access (aren't you) so for display you sort the table when you read the data

 

[pujo]

well your doing this in access (aren't you) so for display you sort the table when you read the data

Yes, I am doing this in Access and trying to sort this in a query, not a table.

Maybe I am doing it wrong..... still not working

 

[mole999]

so in SQL Query it would be

SELECT *
FROM Tbl
WHERE
ORDER BY probably sort from here

 

[james_lankford]

select 
  year( tbl.[Date of Birth] ) as [Year of DOB], 
  month( tbl.[Date of Birth] ) as [Month of DOB], 
  day( tbl.[Date of Birth] ) as [Day of DOB], 
  tbl.YourPrimaryKey 
from
  tbl 
order by 
  year( tbl.[Date of Birth] ), 
  month( tbl.[Date of Birth] ), 
  day( tbl.[Date of Birth] )