Thank you for this bit of code. I have a database at work where we show birthdays of employees, their date of birth is stored in one field. In a new query I have added the original table info plus a field called "Month" using:
Month: Format([Date Of Birth],"mm")
This then shows the month...