Search results for query: *

All, I'm creating a Performance Tracking database at work, for disiplanary actions... When on the subform, you update the field VioCode I want it to check that value against a table called PtsSource, and find the value of SourcePoints where VioCode (from the form) is equal to SourceCode...

Here's the code that worked: SELECT EmpTable.EmployeeID, Sum(ClassDates.Hours) AS SumOfHours, EmpTable.LastName, EmpTable.FirstName FROM EmpTable LEFT JOIN ((Classes LEFT JOIN ClassDates ON Classes.ClassID = ClassDates.ClassID) RIGHT JOIN Enrollment ON Classes.ClassID = Enrollment.ClassID) ON...

THANKS to All... Finally got it... It was more than just the Join b/w the Enrollment and EmpTable, every join had to be adjusted just right (also b/w Enrollment and Classes (right join to Enrollment) and b/w Classes and ClassDates [qry that finds the hours per class, and also filters the...

I've tried changing the joins before, to no avail... What sql code would help... Here's the code for the exisiting (semi-working) query: SELECT EmpTable.EmployeeID, Sum(ClassDates.Hours) AS SumOfHours FROM EmpTable INNER JOIN ((Classes INNER JOIN ClassDates ON Classes.ClassID =...

So, I've created a simple database for tracking In-Service hours for the lifeguards at my facility. Only three tables, one for the Employees, one that holds the information about each class, and an Enrollment table that combines ClassID's and EmployeeID's. I need a query that will tell me how...