orangejosh
Technical User
Hello. I have the following SQL query:
I'd like to add start and end dates to this. Right now, it just gives me back the total hours in the entire table. For example, I'd like to only know the hours between 4/15/2006 and 5/1/2006. Thanks!
Code:
SELECT Sum(usersProjectDetail.userProjectDetailHours) AS TotalHours
FROM (users INNER JOIN (project INNER JOIN usersProject ON project.projectID = usersProject.projectID) ON users.userID = usersProject.userID) INNER JOIN usersProjectDetail ON usersProject.userProjectID = usersProjectDetail.userProjectID
WHERE (((users.userID)=1) AND ((usersProject.projectID)=17));
I'd like to add start and end dates to this. Right now, it just gives me back the total hours in the entire table. For example, I'd like to only know the hours between 4/15/2006 and 5/1/2006. Thanks!