Current Month/Year Query

[Roadbeer]

Hey all,

I've been beating my head against the wall on this...

I have a table called "Payments" and I'm trying to get the query to filter out all payments other than those for the current month and year.

It seems like something simple, but I can't pull it off



Thanks in advance.

[pbaldy]

You can either use functions to get the dates and use Between or the Month() and Year() functions, like:

WHERE Month(DateField) = Month(Date()) And Year(DateField) = Year(Date())

[Roadbeer]

That did it, I knew it was simple.

Thanks a bunch

[pbaldy]

No problemo!