Jumat, 02 Januari 2015

[MS_AccessPros] Previous Month Filter

 

I have a filter that calls for the previous month

"

Year([Test_Date]) = Year(Now()) And Month([Test_Date]) = Month(Now()-1)

"

did not think about January of the next year.  Any help would be appreciated.



__._,_.___

Posted by: statmanbp@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar