Birth date

[Lost in Virginia]

I created a table with standard information name, Birthday, Date of Hire etc.
Now I want to create a query for birthday and break it down to month only
January, February, etc. The query part was easy but I can't figure out the
function I need to only list the months that I want. Any assistance would be
greatly appreciated.

 

[John Spencer MVP]

Add another column to the query. You can choose not to show the column.

Field: Month(BirthdayField)
Criteria: [Enter Month Number]

When prompted enter a number from 1 to 12.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County