Simple (ish) Query Involving a YearToDate Sales Figure
Posted on 2013-11-06
I want a query that gives me a YearToDate Sales figure by salesman (using "group by").
The slightly tricky bit is that the "current month" is determined by tblParameters.ParameterValue where ParameterNumber=3.
The end result should look something like;