Filter By Month

**Indikirt** · 12-16-2010, 11:18 AM

Hi Everyone,

Please help!

I have created a query in access 2007, listing all employees and their Date Of Birth. How can i add a filter to search by a specific month.

Thanks

**alansidman** · 12-16-2010, 04:27 PM

Are you interested in generating a query for your filter? Do you want it in a report? Or do you just wish to have it on your form. Some more details would help to understand where and how you wish to filter.

Alan

**Indikirt** · 12-17-2010, 07:05 AM

Hi Alan

Thanks for responding.

i am interested in generating a query for my filter.

**alansidman** · 12-17-2010, 02:47 PM

In a new field in your query, type MonthDate: Month(FieldNameHavingDateofBirth)
Now in the criteria for the new field, put whatever month you want to filter on, using the month numbers, ie. 1= January, 2= February, etc.

Thread: Filter By Month

Thread Tools

Rate This Thread

Display

Filter By Month

Re: Filter By Month

Re: Filter By Month

Re: Filter By Month

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions