access project

SELECT [tblLocation].[LocationID], [tblLocation].[LocationName] FROM tblLocation;

PARAMETERS __LocationID Value; SELECT DISTINCTROW * FROM qryTrainersAndSessions AS frmLocationSessions WHERE ([__LocationID] = LocationID);

SELECT [tblTrainer].[TrainerID], [tblTrainer].[Last], [tblTrainer].[First] FROM tblTrainer;

PARAMETERS __TrainerID Value; SELECT DISTINCTROW * FROM tblBilling AS frmTrainersBilling WHERE ([__TrainerID] = TrainerID);

SELECT DISTINCTROW * FROM tblBilling;

SELECT DISTINCTROW * FROM tblLocation;

SELECT DISTINCTROW * FROM tblTrainer;

SELECT tblTrainer.TrainerID, tblTrainer.First, tblTrainer.Last, tblClient.ClientID, tblClient.ClientFirst, tblClient.ClientLast, tblBilling.Sessions, tblBilling.Amount FROM tblTrainer INNER JOIN (tblClient INNER JOIN tblBilling ON tblClient.[ClientID] = tblBilling.[ClientID]) ON tblTrainer.[TrainerID] = tblBilling.[TrainerID] ORDER BY tblTrainer.Last, tblClient.ClientLast, tblBilling.Amount;

SELECT tblEmployee.EmployeeID, tblLocation.LocationID, tblLocation.LocationName, tblEmployee.First, tblEmployee.Last, tblEmployee.Title, tblEmployee.MonthlySalary, tblLocation.ManagerID FROM tblLocation INNER JOIN tblEmployee ON tblLocation.LocationID = tblEmployee.LocationID ORDER BY tblEmployee.Last;

SELECT [First] & ' ' & [Last] AS TrainerName, tblTrainer.LocationID, Sum(tblBilling.Sessions) AS SumOfSessions FROM tblTrainer INNER JOIN tblBilling ON tblTrainer.TrainerID = tblBilling.TrainerID GROUP BY [First] & ' ' & [Last], tblTrainer.LocationID;

SELECT tblBilling.ClientID, [First] & ' ' & [Last] AS TrainerName, tblLocation.LocationID, tblLocation.LocationName, Sum(tblBilling.Sessions) AS SumOfSessions FROM (tblLocation INNER JOIN tblTrainer ON tblLocation.LocationID = tblTrainer.LocationID) INNER JOIN tblBilling ON tblTrainer.TrainerID = tblBilling.TrainerID GROUP BY tblBilling.ClientID, [First] & ' ' & [Last], tblLocation.LocationID, tblLocation.LocationName;

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