R
red6000
Hi I have a table called 'Tasks'.
It has 3 colums:
WorkDate
TaskName
TimeSpent
I can write the SQL to sum up the total time spent for various time frames,
ie:
SELECT Tasks.WorkDate, DSum("TimeSpent","Tasks") AS TotalTime
FROM Tasks
WHERE (((Month([WorkDate]))=[Enter Month]))
GROUP BY Tasks.WorkDate;
What I want is for the results to group together each task and the relevant
subtotal. However if I add the Tasks to the above, it just shows the full
total for each task?
Any help appreciated.
Thanks
It has 3 colums:
WorkDate
TaskName
TimeSpent
I can write the SQL to sum up the total time spent for various time frames,
ie:
SELECT Tasks.WorkDate, DSum("TimeSpent","Tasks") AS TotalTime
FROM Tasks
WHERE (((Month([WorkDate]))=[Enter Month]))
GROUP BY Tasks.WorkDate;
What I want is for the results to group together each task and the relevant
subtotal. However if I add the Tasks to the above, it just shows the full
total for each task?
Any help appreciated.
Thanks