Thread: Query with Date/Time field to Month

Access 2007
Existing Data Base:
In performing a Query of a data base that has a field that is Date/Time set to Medium Date, this field has dates that cover multiple years and all months of the year. The field needs to be set to Medium Date to comply with other reports that are required to do.

Problem:
In using this field, how do I separate out only the January or June or December month for a report [having multiple years is no a problem]?
In using this field, how do I separate out a month of a specific year {ex: January, 2009 or May, 2008}?

I want to Thank each individual that responds in advance for their help with this problem.

To select all records in a certain month:

SELECT * FROM tablename WHERE MONTH(datefield) = #;

# will be the number of the month (1 for Jan, 2 for Feb, etc.)
To select all records in a certain month and a certain year:

SELECT * FROM tablename WHERE MONTH(datefield) = # AND YEAR(datefield) = ####;

I assumed you had an existing query set up. If not, you'll have to create a new one.

davegugg

I got it to work.

I want to THANK YOU in advance for your assistance with this problem.

Autin