sum function in access 03 expression builder.

[phoenix-flames]

this is one of the questions i have been given for a project at university:

8. List details of all the projects, together with the cost of each project. The cost of the project should be calculated from the total fixed cost of all the tasks in the project, plus the labour cost of the work done by the employees assigned to the tasks in the project. The labour cost for an employee is calculated as the annual salary multiplied by the number of days assigned to the task divided by 20.

for the section in bold i am trying to use the sum function, however when i try and run the query it comes back saying

"you tried to excecute a query that does not include the specified expression 'projectID' as part of an aggregate function"

any ideas on what im doing wrong. i feel i will be able to do the rest of the question myself if i can get the sum function working. I have included a screenshot of what tables/fields etc i have put in so far.

[S_Herbie]

Rather than using the [Task] table, use a sub query that aggregates the [fixedCost] by [projectID].

Something like:

SELECT Task.projectID, Sum(Task.fixedCost) AS SumOffixedCost
FROM Task
GROUP BY Task.projectID;

[phoenix-flames]

cheers mate i finally got it workin like that this morning, nice to know i did it right tho :laugh: