Return Month and Day form DOB

[Guest]

How can I return month and date from Birthdate field in Access 2003? Thanks.

 

[Ken Snell \(MVP\)]

Use a query:

SELECT Format([FieldName], "mm\/dd") AS BirthMonthDay
FROM TableName;