S
scubadiver
I have inserted an SQL statement into the properties of a chart so that it
will include information for the ten most recent weeks.
SELECT FTE.WeekID, [count]-[FTE] AS Admin
FROM FTE INNER JOIN Query2 ON (FTE.WeekID = Query2.WeekID) AND (FTE.Dept =
Query2.Dept)
WHERE (((FTE.WeekID)>=DateAdd("ww",-10,Date())) AND
((FTE.Dept)="Administration"))
ORDER BY FTE.WeekID;
What I would like to do is calculate the average of "[count]-[FTE]" for the
ten weeks.
cheers in advance
will include information for the ten most recent weeks.
SELECT FTE.WeekID, [count]-[FTE] AS Admin
FROM FTE INNER JOIN Query2 ON (FTE.WeekID = Query2.WeekID) AND (FTE.Dept =
Query2.Dept)
WHERE (((FTE.WeekID)>=DateAdd("ww",-10,Date())) AND
((FTE.Dept)="Administration"))
ORDER BY FTE.WeekID;
What I would like to do is calculate the average of "[count]-[FTE]" for the
ten weeks.
cheers in advance