Killer query

Wow. I just learned the value of the phrase "just say no." I was asked if I know MS Access and I said yes. Because I thought I did. However, I realized I'm a novice now because I've been handed a db and was asked to "go to work." Now I'm stuck on query #1 and need help. Can anyone help me step through this query? I'm getting triped up at the AS statement.

I think I may be asking for a Access 101 crashcourse.

Adjusted Monthly Query

SELECT X_Ref_Week_Month.Month, AdjustedWeeklyHours.Resource_Name, Sum(AdjustedWeeklyHours.Adj_Hours) AS SumOfAdj_Hours

FROM AdjustedWeeklyHours INNER JOIN X_Ref_Week_Month ON AdjustedWeeklyHours.Time_Period = X_Ref_Week_Month.Week_End

GROUP BY X_Ref_Week_Month.Month, AdjustedWeeklyHours.Resource_Name;

I guess I'm not sure what you are asking.


The "AS" is Identifying the name of the column in the select portion of you statement

S_

I finally got it. Using help and a little investigating I figured out what it's doing. Thanks