Current Month

[Saifon]

Hi

Probably an easy one here.. Got a table that I will like to do a query on.. All I need is to list all records for the current month. So obviously, when it goes to the next month, the query would update and show only records for that month.

What do I need to put under the date criteria to get this query?!?.. Any ideas?

Thanks
Saifon

 

[Jon K]

Put this in a new column in the query grid (replacing with the correct date field name):-

Field: Format([DateField],"yyyymm")

Show: uncheck

Criteria: Format(Date(),"yyyymm")
.

 

[Rebel]

Thanks

Thanks, Saifon, for posting this question. I have the same problem, but just the opposite: I want to leave out the current date. You saved me the time of typing my question out.

And a big "Thank You" to you, Jon, for a nice simple answer.

 

[Saifon]

Perfect... exactly what I was looking for.. .. thanks.. I owe you a pint..

Saifon