I have a form that opens and shows the empoyees commissions real time. so as they make sales the form updates to show them the earned commission. The problem Im having is......When the month changes to a new month I still see last months sales. How can I have last months sales not show and start new for the next month?

---

Reply from Alex Hedley:

If your Query you could have a Criteria of Month(Date) = Month(Now)