2. ASPRunnerPro General questions
  3. Month to Date report
This topic is locked

Month to Date report

 		8/1/2007 2:34:46 PM
ASPRunnerPro General questions
S
 superkev72 author

I am trying to figure out how to perform a month to date report.
For example, a link or method somewhere where an employee could click and see their month to date sales or how many of a particular item was sold during the current month.
Thanks in advance for any help.
Sergey Kornilov admin 8/2/2007

You can add a WHERE clause to SQL query to return only records that belong to the current month only.
In MS Access you can use month() function for this purpose

WHERE Month(DateField)=Month(Now()) and Year(DateField)=Year(Now())