Listing just a single actual months events from a table over a number of years.

[jimsunz]

In Access I have a table of events with one column having the date
dd/mm/yyyy.
I want to, for example, list all the events that took place in the
month of February in all years.
so it would extract 12/02/1999, 25/02/2003 and so on.

And then later,all the November events, etc.

Thanks for your help.
Jim.

 

[Frank Kabel]

Hi
you may post this to the Access NG. But also Acces should have a month
function IIRC and you could create a user defined field in your query

 

[jimsunz]

Thank you Frank. Do you know where I would find the Access NG.
Many thanks Jim.

 

[Debra Dalgleish]

You can post to the Access newsgroups through the Microsoft web site:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx#2