Newbie: SQL date problem

[orangejosh]

Hello. I have the following SQL query:

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!

 

[Golom]

In the WHERE clause remove the semi-colon and add

AND SomeDateField BETWEEN [Start Date] AND [End Date]

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[orangejosh]

Thanks, that did it!