Greater Than Current Month

I have a field:  [ValueDate] in mm/dd/yy
What would be the query criteria to exclude records that are in the same month of current date and only show records that are > the month of the current month?
ie:
Current Month = October

ValueDate = 10/20/16
ValueDate = 10/1/16
dont show these records because the current month is October.  

ValueDate = 11/1/16
==>show this record and any other records that are >current month "mmmm"

Not sure exactly how to say it in words.  Please ask if have questions.
pdvsaProject financeAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
Field:  Format([ValueDate], "yyyy mm")
Table Name


criteria  >Format(Date(),"yyyy mm")
0
 
pdvsaProject financeAuthor Commented:
I almost had it.  
I didnt use yyyy mm...

thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.