Query criteria for current month

[JimO]

I am looking to replace my current criteria from ( Between #3/1/2016# And #3/31/2016#) to something that will automatically select the current month range. I don't need to type in a range every time I run the query.

Jim O

[rpeare]

between DateSerial(DatePart("yyyy",Date()),DatePart("m",Da te()),1) and DateAdd("d",-1,DateAdd("m",1,DateSerial(DatePart("yyyy",Date()) ,DatePart("m",Date()),1)))

[JimO]

I am getting an Invalid Syntax message.
Jim O

[JoeM]

It looks like an extra space just got accidentally inserted in his reply.
Try replacing "Da te()" with "Date()", and it should work (it does for me).

[JimO]

I should have noticed that. Thanks for the extra set of eyes. It seems to be working now. I can do these 'formulas' in excel but this Access is very new to me.

thanks again.
Jim O