General discussion

Locked

Need to filter Access for Month

By mitchbryant ·
I need to filter an Access 97 Query for the current month/year.... Got a line that will work.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Need to filter Access for Month

by sgt_shultz In reply to Need to filter Access for ...

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())

Collapse -

Need to filter Access for Month

by mitchbryant In reply to Need to filter Access for ...

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...

Collapse -

Need to filter Access for Month

by mitchbryant In reply to Need to filter Access for ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums