Search results

this is what it looks like... i cant seem to change it correctly to work.... SELECT (Format([FT Date],"WW 'YY")),Sum([SumOfSum Of From]) AS [SumOfSumOfSum Of From] FROM [Chart Abs 1 T] GROUP BY (Year([FT Date])*CLng(54) + DatePart("ww",[FT Date],0)-1),(Format([FT Date],"WW 'YY")); any help?

making a chart amount on the Y axis and date by week on the X axis... when i do this the date shows up as the week number instead of date (34 '07 for example) can i change this to a date instead?