R
red6000
Hi, I have the following SQL
SELECT Activities.TaskName, DSum("TimeSpent","Activities","TaskName = '" &
[TaskName] & "'") AS TotalTime
FROM Activities
WHERE (((Activities.WorkDate) Between [Start Period] And [End Period]))
GROUP BY Activities.TaskName
ORDER BY Val(DSum("TimeSpent","Activities","TaskName = '" & [TaskName] &
"'")) DESC;
However it isn't filtering out the records where the date is outside what I
specify?
Any ideas
Many thanks.
SELECT Activities.TaskName, DSum("TimeSpent","Activities","TaskName = '" &
[TaskName] & "'") AS TotalTime
FROM Activities
WHERE (((Activities.WorkDate) Between [Start Period] And [End Period]))
GROUP BY Activities.TaskName
ORDER BY Val(DSum("TimeSpent","Activities","TaskName = '" & [TaskName] &
"'")) DESC;
However it isn't filtering out the records where the date is outside what I
specify?
Any ideas
Many thanks.