Thanks for the quick response. Keep in mind that I am somewhat of a newbie when I ask my questions. As you may recall, I changed the Field "ToDate" to: Weekending: [ToDate]-2 so that I could capture each week ending on a Friday.
Therefore, does my code go in the criteria line for the new field "Weekending" or do I add my previous field name "ToDate" and include the criteria line there? I have tried putting the code under either of these field names and in each case I get the error "Invalid Procedure".
Below is my SQL where it looks like additional parenthesis were automatically added to the end.
SELECT ([AvgWrap]+[AvgAtt]) AS ACHT, [ToDate]-2 AS Weekending, [SumOfAns]/[SumOfTotHandled] AS AvTSF, Sum([CS Natl wk].TotOffer) AS SumOfTotOffer, Sum([CS Natl wk].TotHandled) AS SumOfTotHandled, Sum([CS Natl wk].TotAband) AS SumOfTotAband, Avg([CS Natl wk].ASA) AS AvgOfASA, [SumofTotAband]/[SumOfTotOffer] AS PercentOfCanc, Sum([CS Natl wk].As) AS SumOfAs, [SumOfAs]/[SumOfTotHandled] AS AvgASA, Sum([CS Natl wk].Ans) AS SumOfAns, AvgEmpPID.Avg AS Expr1, Sum([CS Natl wk].Aw) AS SumOfAw, Sum([CS Natl wk].At) AS SumOfAt, [SumOfAw]/[SumOfTotOffer] AS AvgWrap, [SumOfAt]/[SumOfTotHandled] AS AvgATT, [CS Natl wk].ToDate
FROM [CS Natl wk] INNER JOIN AvgEmpPID ON [CS Natl wk].ToDate = AvgEmpPID.Weekending
GROUP BY [ToDate]-2, AvgEmpPID.Avg, [CS Natl wk].ToDate
HAVING ((([CS Natl wk].ToDate) Between (DateAdd("“ww”",-3,(Date()-Day(Date())))-Day(DateAdd("“ww”",-3,(Date()-Day(Date())))))+1 And (Date()-Day(Date()))));