Month

[jebi_babu]

Hi,
I am a very new guy in access. One very simple question.
How can I give crieteria for to get a query result for month and year
ie. i know DATE() is for today
between[start date]and [end date] gets from a date to a date
but i wanted to get particular month and year. How to write this?
Hope somebody will help in this matter.
thx and regards
nowfal

 

[MStef]

Helo hebi babu!

Look at "DemoYMA2000.mdb", open form and try.

 

[jebi_babu]

thank you very much Mstef.
bye
nowfal

 

[jebi_babu]

Related question

Hi,
If i wanted the query as 2005 JAN insted of yyyymm(200501).Is it possible to change the field?
thanks
nowfal

 

[Rich]

Format (YourField),"YYYY,MMM")

 

[MStef]

Helo hebi babu!
Look at "DemoYMA2000.mdb"