Software

Ask something
Discussion Locked

Need to filter Access for Month

0 helpful
3 replies

by mitchbryant 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to filter an Access 97 Query for the current month/year.... Got a line that will work.

3 replies

by sgt_shultz

assuming a field called, say, OrderDate.
use this expression in your query to return records with order date in current year and month:
---------
Year([OrderDate]) = Year(Now()) And Month([OrderDate]) = Month(Now())

by mitchbryant

Thank you! Awesome.... That worked and I appreciate very much you helping a novice Access non-programmer... The fuuny thing was that was the name of my field as well, so copy and paste and dropping it in was perfect...

This discussion is closed to new replies.