R
red6000
Hi,
I have a table of data and run a query (see below). What I would like to do
is amend the results in the query data view so that the main table is
updated. Is this possible, if so can you point me in the right direction?
I had looked at using an 'Update' query, but that doesn't appear to be what
i'm after.
Thanks.
SELECT Activities.TaskName, DSum("TimeSpent","Activities","TaskName = '" &
[TaskName] & "'") AS TotalTime
FROM Activities
WHERE (((Activities.WorkDate)=Forms!InputForm2!MainTimesheet.Form!WorkDate)
And ((Activities.CSTRName)=Forms!InputForm2!MainTimesheet.Form!EmployeeID))
GROUP BY Activities.TaskName, Activities.WorkDate
ORDER BY Val(DSum("TimeSpent","Activities","TaskName = '" & [TaskName] &
"'")) DESC;
I have a table of data and run a query (see below). What I would like to do
is amend the results in the query data view so that the main table is
updated. Is this possible, if so can you point me in the right direction?
I had looked at using an 'Update' query, but that doesn't appear to be what
i'm after.
Thanks.
SELECT Activities.TaskName, DSum("TimeSpent","Activities","TaskName = '" &
[TaskName] & "'") AS TotalTime
FROM Activities
WHERE (((Activities.WorkDate)=Forms!InputForm2!MainTimesheet.Form!WorkDate)
And ((Activities.CSTRName)=Forms!InputForm2!MainTimesheet.Form!EmployeeID))
GROUP BY Activities.TaskName, Activities.WorkDate
ORDER BY Val(DSum("TimeSpent","Activities","TaskName = '" & [TaskName] &
"'")) DESC;