A few words of thanks would be greatly appreciated.

Access: Filter a date

Access: Filter a date


I like to make a query (Access 2007) that can extract the month from a date.
Here's the background:

I have a table RENDEZVOUS, which contains several fields including the one that interests us: Date (dd / mm / yyyy)

I would like to create an application that allows me to extract the month of all dates, according to a filter.

For example, I want all Appointments that are in the month of May.

I hope my explanation is not too confusing ...
I found a lot of similar requests by searching on the net, but none matched ...

Thank you in advance for your help.


In Access 2007 you can either use the SQL for your query by clicking the dropdown in the upper left (under the 'View') then 'SQL mode'.

If you do not want to go through the SQL in your application you created a field containing:
Month (mon_champ_date)
and criteria you enter the number of months you want.

If the number of months must be selected on a form, for example, you can put in the criteria field:
Forms! [Mon_formulaire]! [Name_du_champ_contenant_le_mois_choisi]


Solved by Gaunts

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Access: Filter a date », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).