var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Groups Dates by DayofWeek
I am trying to do a stats query that will group all of the date fields in "IncidentDate" by the day of week.
Monday 7 ... etc...
I have been playing with the "dayofweek" and "datepart" function, but I am not sure how to use them in the SQL stmt for the entire week.
I tried something like this in the Query Designer, but this gives me errors.
I've searched the forums by no luck.
Any help would be appreciated...
Try somehting like:
SELECT Weekday(incidentDate) AS Week_day, Sum(myValueToSum) AS my_Total
GROUP BY Weekday(incidentDate);
That actually worked perfectley... I just had to add a very large IIF stmt on my report to display Sun to Sat..