Trying to create a graph, but instead of having the date of results, I'd like to group the data by the "week of". For instance, the week of (May 29, 2006). What am I missing for that format that i'd use in this guery.
Here is my sql:
As of right now, this is what I am getting:
Query1
Week Of
3 '06
21 '06
22 '06
Thank you in advance.
Kilch
Here is my sql:
Code:
TRANSFORM Sum(qry_Sum_Returned.CountOfFab_Fab_DataId) AS SumOfCountOfFab_Fab_DataId
SELECT (Format([Fab_Date_Recd],("ww"" '""yy"))) AS [Week Of]
FROM qry_Sum_Returned
GROUP BY (Year([Fab_Date_Recd])*CLng(54)+DatePart("ww",[Fab_Date_Recd],2)-1), (Format([Fab_Date_Recd],("ww"" '""yy")))
PIVOT Format([Fab_Date_Recd],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
As of right now, this is what I am getting:
Query1
Week Of
3 '06
21 '06
22 '06
Thank you in advance.
Kilch