access projact

SELECT [FirstName] & " " & [LastName] AS StudentName, [_GradingReport].ProjectName, "Submission #" & [SubmissionNum] AS SubmissionCt, "Score is " & [Score] & " out of " & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & ". " & [Description] AS Step, GradingSummaryReportGrade.AllowPartialGrading, GradingSummaryReportGrade.Action_CT, GradingSummaryReportGrade.ActionCorrect, roundScore([AllowPartialGrading],[GradingSummaryReportGrade].[StepMaxScore],[ActionCorrect],[Action_CT]) & "/" & [GradingSummaryReportGrade].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingReportSteps].Description FROM _GradingReport, _GradingReportSteps INNER JOIN GradingSummaryReportGrade ON [_GradingReportSteps].StepNumber = GradingSummaryReportGrade.StepNumber;

SELECT [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepScore AS AllowPartialGrading, [_GradingReportSteps].StepMaxScore, Count([_GradingReportSteps].ID) AS Action_CT, Sum(IIf([IfSuccessful]=-1,1,0)) AS ActionCorrect, Sum(IIf([IfSuccessful]=0,1,0)) AS ActionWrong FROM _GradingReportSteps GROUP BY [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepScore, [_GradingReportSteps].StepMaxScore;